Locale problem

go wrote:

Hi !

Im running PG 7.23 now with text fields in CP866.

I tried to restore dump from 7.23 into PG 8.01 with
following settings :
- initdb --locale ru_RU
- createdb -E ALT.

all works great , but sort order in text fields is wrong

Both on Linux and Windows you should use for your databases the same
encoding as your system supports. On Linux you can see your locales
using 'locale -a'. On my Linux I have these ru_RU.*:

ru_RU
ru_RU.iso88595
ru_RU.koi8r
ru_RU.utf8

I would try 'initdb --locale ru_RU.utf8' (or any other with specified
encoding) and set the same encoding for the database (= in this example
'UNICODE'). Then the sorting should be correct.

I'm just a newbie for PostgreSQL so somebody might explain it more
precisely.

People, help pls to megrate to PG 8.01 properly

Thanks, and have a nice day!!

Igor

Miroslav �ulc