Locale problems - Mailing list pgsql-admin

From Aleksander Kmetec
Subject Locale problems
Date
Msg-id 3E4C06BA.1020202@spletzone.com
Whole thread Raw
List pgsql-admin
Hello!

I have a db cluster which contains databases with LATIN2 encoding and
some databases with UNICODE encoding. If I initalise the cluster with
--locale=sl_SI option, then special characters in LATIN2 databases are
sorted correctly, but special chars in UNICODE dbs end up in wrong
places; and the other way around if I use sl_SI.utf8 locale (or no locale).

Is there a way to get correct sorting order in both cases, other than
running two separate servers? ( pg 7.3.1 )

Thank you.

Best regards,
Aleksander


pgsql-admin by date:

Previous
From: "Jose Antonio Martinez"
Date:
Subject: Re: postgresql mysql max connections
Next
From: "guillermo schulman"
Date:
Subject: backup/restore and vacuumdb