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

From Vegard Munthe
Subject Re: Problems with lower('Å')
Date
Msg-id 20021220162024.R76859-100000@unity.copyleft.no
Whole thread Raw
In response to Re: Problems with lower('Å')  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> > '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.

Ok. Thank you very much.

-- Vegard Munthe


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with lower('Å')
Next
From: Scott Lamb
Date:
Subject: Re: IN or EXISTS?? faster one