Обсуждение: How may I set LC_COLLATE and LC_CTYPE to Russian_Russia.1251 on Fedora Core Linux?

Hello!

When I install Postgresql 8.0.3 on my Windows server, I set LC_COLLATE
and LC_CTYPE to Russian_Russia.1251 via install process.

But when I install Postgresql server on Fedora Core 4 Linux, I can't
set LC_COLLATE and LC_CTYPE to Russian_Russia.1251. Maximum, that I
may set, is ru_RU.KOI8-R.
What I need to set regional setting to Russian_Russia.1251 ?

I seek all docs about Postgresql, but can't find anything about
Russian_Russia.1251....

My server has this locales:
locale -a |grep ru
ru_RU
ru_RU.iso88595
ru_RU.koi8r
ru_RU.utf8
russian
ru_UA
ru_UA.koi8u
ru_UA.utf8

With best regards
Roman

Петров Р.В. wrote:
> But when I install Postgresql server on Fedora Core 4 Linux, I can't
> set LC_COLLATE and LC_CTYPE to Russian_Russia.1251. Maximum, that I
> may set, is ru_RU.KOI8-R.
> What I need to set regional setting to Russian_Russia.1251 ?

You can only use locales that the host operating system supports.  On
Windows you can use Windows-style locales, on Linux you will need to
use Linux/POSIX-style locales.  So ru_RU.KOI8-R is probably a good
choice, although other people more familiar with the matter may give
you better advice on a good choice of particular character encoding
combinations in heterogenous environments.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Петров Р.В. wrote:
> But when I install Postgresql server on Fedora Core 4 Linux, I can't
> set LC_COLLATE and LC_CTYPE to Russian_Russia.1251. Maximum, that I
> may set, is ru_RU.KOI8-R.
> What I need to set regional setting to Russian_Russia.1251 ?

You can only use locales that the host operating system supports.  On
Windows you can use Windows-style locales, on Linux you will need to
use Linux/POSIX-style locales.  So ru_RU.KOI8-R is probably a good
choice, although other people more familiar with the matter may give
you better advice on a good choice of particular character encoding
combinations in heterogenous environments.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match