unicode sorting problems - Mailing list pgsql-general

From Aleksander Kmetec
Subject unicode sorting problems
Date
Msg-id 3E736DF3.8000308@spletzone.com
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: The folding of unquoted names to lower case in
Next
From: "Yudha Setiawan"
Date:
Subject: OOT-Does PostgreSQL has commercial level.