Re: postgreSQL UPPER Method is converting the character "µ" into "M" - Mailing list pgsql-general

From Tom Lane
Subject Re: postgreSQL UPPER Method is converting the character "µ" into "M"
Date
Msg-id 1507834.1694008417@sss.pgh.pa.us
Whole thread Raw
In response to postgreSQL UPPER Method is converting the character "µ" into "M"  (Sai Teja <saitejasaichintalapudi@gmail.com>)
Responses Re: postgreSQL UPPER Method is converting the character "µ" into "M"  (Sai Teja <saitejasaichintalapudi@gmail.com>)
List pgsql-general
Sai Teja <saitejasaichintalapudi@gmail.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



pgsql-general by date:

Previous
From: Sai Teja
Date:
Subject: postgreSQL UPPER Method is converting the character "µ" into "M"
Next
From: Sai Teja
Date:
Subject: Re: postgreSQL UPPER Method is converting the character "µ" into "M"