Postgres Pro
Downloads
Home   >   mailing lists

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

From Sai Teja
Subject postgreSQL UPPER Method is converting the character "µ" into "M"
Date
Msg-id CADBXDMXKnWKVY=5_q0Ww79dXd3e9x1M2t0S_ivVhk4VAma_Y0A@mail.gmail.com
Whole thread Raw
Responses Re: postgreSQL UPPER Method is converting the character "µ" into "M"
Re: postgreSQL UPPER Method is converting the character "µ" into "M"
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Pgbackrest Restore Error - Segmentation fault (core dumped)
Next
From: Tom Lane
Date:
Subject: Re: postgreSQL UPPER Method is converting the character "µ" into "M"