Re: setting the environment locale - linux, windows - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: setting the environment locale - linux, windows
Date
Msg-id 20060421131835.GB29659@svana.org
Whole thread Raw
In response to setting the environment locale - linux, windows  ("Tomi NA" <hefest@gmail.com>)
Responses Re: setting the environment locale - linux, windows  ("Tomi NA" <hefest@gmail.com>)
List pgsql-general
On Fri, Apr 21, 2006 at 12:49:31AM +0200, Tomi NA wrote:
> This is probably somewhat offtopic, but it does relate to postgresql so...
> Problem summary: I have a UTF-8 encoded database running on linux on
> which upper() and lower() string functions ignore locale specific
> characters.

You need to look at your LC_COLLATE settings. LC_COLLATE and LC_CTYPE
are fixed at initdb and constant across the DB.

> Are there plans to enable assigning locale at the database level?

Plans, yes. Progress, a bit slow...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: CG
Date:
Subject: Re: GiST index slower than seqscan
Next
From: "Tomi NA"
Date:
Subject: Re: setting the environment locale - linux, windows