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

Hi Tom Lane, Thank you for your reply!

Actually we are migrating the data from DB2 to postgreSQL. So in DB2 the
upper method is converting µ as µ only but not as M.

So, while validating the data we have encountered this problem.

We want to have the data in both DB's should be similar (db2 and postgreSQL)

In my local it is windows OS and locale is English_united_states.1252 and
in local it is converting as expected ( testµ into TESTµ)

So, even I want to change locale i cannot change now. Since already db is
created. BTW this db is hosted in azure.

Would request to please suggest if any alternatives are there to resolve
this issue.

Thanks,
Sai Teja

On Wed, 6 Sep, 2023, 7:23 pm Tom Lane, <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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
>