Thread: Locale problem
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 People, help pls to megrate to PG 8.01 properly Thanks, and have a nice day!! Igor
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