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

From: Helmut Bender <hab(at)helmut-bender(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: postgreSQL UPPER Method is converting the character "µ" into "M"
Date: 2023-09-06 15:22:50
Message-ID: 7934e62f-516b-820d-1d37-7b915f5dd7a4@helmut-bender.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 06.09.23 um 16:04 schrieb Sai Teja:
> 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µ)

You wrote PostgreSQL is hosted on an utf-8 system. That's why it's
working different.

And be careful: the M isn't the uppercase latin m, but in fact the
uppercase µ (U+039C in unicode)! If you would compare it to latin
alphabet 'TESTM' it would be different.

--
Gruß Helmut

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2023-09-06 15:29:21 Re: postgreSQL UPPER Method is converting the character "µ" into "M"
Previous Message Albrecht Dreß 2023-09-06 14:51:27 Q: inet operators for IPv4 encapsulated in IPv6