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.