unicode sorting problems

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

Browse pgsql-general by date

  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