VÃclav VozÃr wrote: > 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 [EMAIL PROTECTED])
