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 [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
