Re: Locale bug?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Václav Vozár <vaclav(dot)vozar(at)emicad(dot)cz>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Locale bug?
Date: 2004-08-10 19:29:04
Message-ID: 200408102129.04838.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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/

In response to

  • Locale bug? at 2004-08-10 10:24:10 from Václav Vozár

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-08-10 21:19:54 Re: OSX problem with make check...
Previous Message Tom Lane 2004-08-10 19:26:04 Re: 8.0.0beta1: make check fails on solaris8