From: | Aleksander Kmetec <alex(at)spletzone(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | unicode sorting problems |
Date: | 2003-03-15 18:16:19 |
Message-ID: | 3E736DF3.8000308@spletzone.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello!
I'm having problems with sort order of special characters in a db
cluster which contains LATIN2 and UNICODE databases.
If I initialise the cluster without a locale or with sl_SI.utf, then
only the sort order for unicode databases is correct and special chars
end up in wrong places in latin2 databases - and the other way around
when using sl_SI as cluster locale.
Is there a way to get correct sorting order in both cases, other than
running two separate servers with two separate clusters?
Is creating all databases with unicode encoding and setting
client_encoding to latin2 (where needed) a valid solution to this
problem? Will there be a noticable delay when reading data?
I'm using Postgres 7.3.1
Thank you.
Best regards,
Aleksander
From | Date | Subject | |
---|---|---|---|
Next Message | Ezra | 2003-03-15 22:06:26 | report generator utility |
Previous Message | Tom Lane | 2003-03-15 16:04:44 | Re: The folding of unquoted names to lower case in |