On 4/21/06, Martijn van Oosterhout <kleptog@xxxxxxxxx> wrote: > 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. So, if I were to backup my database, clear the data directory, reinitialize the cluster and restore the database using the correct LC_COLLATE and LC_CTYPE, I'd have one language nailed? > > Are there plans to enable assigning locale at the database level? > > Plans, yes. Progress, a bit slow... No estimates, then? Nevertheless, thanks for the help. Tomislav
