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

From: Sai Teja <saitejasaichintalapudi(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: postgreSQL UPPER Method is converting the character "µ" into "M"
Date: 2023-09-06 13:42:46
Message-ID: CADBXDMXKnWKVY=5_q0Ww79dXd3e9x1M2t0S_ivVhk4VAma_Y0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi team,

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µ

Here, that character is converting into M which should not be case
The postgreSQL is hosted in Linux Machine which is using Locale_ctype:-
en_US_utf.8

Would request you to please suggest any ideas to resolve this issue.

It'll would be very helpful and appreciated.

Thanks,
Sai Teja

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-09-06 13:53:37 Re: postgreSQL UPPER Method is converting the character "µ" into "M"
Previous Message Rob Sargent 2023-09-06 13:32:49 Re: Pgbackrest Restore Error - Segmentation fault (core dumped)