[BUGS] LATIN2 ORDER BY

[Kristóf Kontor]

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;
Aa
Bb
Áá
...

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])

Re: [BUGS] LATIN2 ORDER BY

[Victor Wagner]

On 2002.08.28 at 13:20:29 +0200, 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)

Are you sure, that you've system locale (LANG variable) set to 
something.ISO8859-2 when you've invoked initdb command?

Are you sure that postmaster process does run with this locale?

Typically debian postinst script takes care of it, but it can fail if
locales package wasn't configured yet when postgresql package is
installed.

These two items are required by postgres to operate correctly with
charsets other than SQLANSI. I've had no problems when I began to take
them into account with any of various cyrillic charsets, since 7.1.0
Actually, only LC_CTYPE and LC_COLLATE categories are needed.

BTW, version of postgresql in Debian woody is 7.2.1
So it is strange, that you have earilier one. Have you installed it from 
Debian package or build by hand? If later, it is better to revert to
Debian version.


-- 
Victor Wagner   [EMAIL PROTECTED]
Chief Technical Officer Office:7-(095)-748-53-88
Communiware.Net Home: 7-(095)-135-46-61
http://www.communiware.net  http://www.ice.ru/~vitus

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]