Re: [BUGS] Locale bug?

#1

Václav Vozár wrote:

Quote:

if I choose in new version 8.0 for win32 czech locales then
lc-collate is czech_czech republic.1250. So I suppose that strings
are compared by WIN1250 charset, but database encoding can't be set
as WIN1250 (only ISO8859-2=LATIN2) and then ORDER BY don't work
correctly. I try make initdb myself, but locales cs_CZ.ISO8859-2 is
wrong name. Where I find suported locales with corect names? Or where
is problem?

Did you set your client encoding? If not, you are probably inserting
WIN 1250-encoded characters without the system knowing about it. If
that happens, the ordering can be incorrect.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] Locale bug?

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] Locale bug? - 08-10-2004 , 05:43 PM