If you seted locales after initdb, then you can have this problem. Try
dump data, remove files in db directory (/usr/local/pgsql/data), check
locales again :->, and initdb -D /usr/local/pgsql/data.
Pavel
On Wed, 28 Aug 2002, Kristóf Kontor wrote:
> Hi !
>
> My problem is that i have LATIN2 encoding in my postgres and
> ISO-8859-2 charset on my linux, but when i'am ordering strings
> in psql with acutes it does not work properly...
> (psql version = 7.1, linux = debian woody)
>
> Example:
> SELECT name FROM table ORDER BY name;
> Aaaaaa
> Bbbbbb
> Áááááá
> ...
>
> I have set evrything on my linux, the 'locale' settings are
> good, the keyboard and console settings are working well,
> with acutes characters, but in the psql it doesent work...
> Can you help me or sending a link or a reference in the
> documentation, cause i cant find anything about this just a few
> row about the locale setting ?
> This is a Linux problem or just a setting in the postgres ?
> What should i reconfig do correct this problem ?
>
> Thanks !
>
>
> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>