Thread: Locale problem

Locale problem

From
go
Date:
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


Re: Locale problem

From
Miroslav Šulc
Date:
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


Attachment