Re: postgreSQL UPPER Method is converting the character "µ" into "M"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sai Teja <saitejasaichintalapudi(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: postgreSQL UPPER Method is converting the character "µ" into "M"
Date: 2023-09-06 13:53:37
Message-ID: 1507834.1694008417@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sai Teja <saitejasaichintalapudi(at)gmail(dot)com> writes:
> I am using UPPER document name for converting the text from lower case into
> upper case.
> But here for the below example
> Command:- select UPPER(testµ)
> Input :- testµ
> Output:- TESTM
> Expected output :- TESTµ

According to https://en.wikipedia.org/wiki/Greek_alphabet
the upper-case form of µ (mu) is in fact M, so I'm not sure
what problem you have with this. But in any case, you are
complaining in the wrong place. This conversion is determined
by the rules of the selected locale. If you don't like it,
choose another locale, or make your own, or try to persuade
the glibc maintainers that they are wrong.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sai Teja 2023-09-06 14:04:40 Re: postgreSQL UPPER Method is converting the character "µ" into "M"
Previous Message Sai Teja 2023-09-06 13:42:46 postgreSQL UPPER Method is converting the character "µ" into "M"