Обсуждение: How may I set LC_COLLATE and LC_CTYPE to Russian_Russia.1251 on Fedora Core Linux?
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
Re: How may I set LC_COLLATE and LC_CTYPE to Russian_Russia.1251 on Fedora Core Linux?
От
Peter Eisentraut
Дата:
Петров Р.В. 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
Re: How may I set LC_COLLATE and LC_CTYPE to Russian_Russia.1251 on Fedora Core Linux?
От
Peter Eisentraut
Дата:
Петров Р.В. 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