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