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

From: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
To: Sai Teja <saitejasaichintalapudi(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: postgreSQL UPPER Method is converting the character "µ" into "M"
Date: 2023-09-06 19:39:08
Message-ID: 20230906213908.465e77cb@karst
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 6 Sep 2023 19:34:40 +0530
Sai Teja <saitejasaichintalapudi(at)gmail(dot)com> wrote:

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

I'm not familiar with PostgreSQL under Windows. Maybe collation from locale
"English_united_states.1252" is available in PostgreSQL? Could you try creating
a database/table/column using this collation?

Or just look at available collations using:

select collname from pg_collation

++

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dirschel, Steve 2023-09-06 20:06:58 Query performance going from Oracle to Postgres
Previous Message Rob Sargent 2023-09-06 19:31:31 Re: Ynt: Pgbackrest Restore Error - Segmentation fault (core dumped)