Which locale to use for multiple-language support? - Mailing list pgsql-general

From David Edwards
Subject Which locale to use for multiple-language support?
Date
Msg-id 608c66280911090257s121a6e43u2feca9687d222c8b@mail.gmail.com
Whole thread Raw
Responses Re: Which locale to use for multiple-language support?
List pgsql-general
Hi,

Some of postgresql's string functions behave differently depending on the locale the cluster was created with. With the locales 'C' or 'en_US.utf8', lower() does not lowercase non-ascii characters such as Ü (umlaut-u).

If we have users from all over the world storing data in our database with all sorts of languages, which locale should we use to ensure these string functions behave as they expect?

Thanks,

--
David Edwards

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: virtualidx exclusive lock
Next
From: Anand
Date:
Subject: Donwload location for PostgreSQL version 8.2.7