Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with lower('Å') - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems with lower('Å')
Date
Msg-id 15449.1040397099@sss.pgh.pa.us
Whole thread Raw
In response to Problems with lower('Å')  (Vegard Munthe <vegard@copyleft.no>)
Responses Re: Problems with lower('Å')  (Vegard Munthe <vegard@copyleft.no>)
List pgsql-general
Tree view 
Vegard Munthe <vegard@copyleft.no> writes:
> 'SELECT lower('�')' returns �. I have tried server_encoding and
> client_encoding LATIN1 and ASCII.

The behavior of lower() is driven by locale, not encoding.
Unfortunately you'll need to re-initdb to change the database locale.

            regards, tom lane

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Database superuser
Next
From: Vegard Munthe
Date:
Subject: Re: Problems with lower('Å')