Hello! 
I have a trouble with PostgreSQL 7.1.3 (and 7.1.2 too). My OS is Solaris 8x86 with russian locale. PostgreSQL was builded from sources and configured with : --enable-locale --enable-multibyte=WIN. 
My problem with sorting lowercase russian words in the text fields (type  -  "varchar") after cyrilic letter "P". 
create table test (id serial, rubrik varchar (255));
Then inserting words in russian (from the client written on php  - encoding win1251)
select * from library order by rubriks - will cause this problem. 
I think that this problem is only on Solaris systems because my friend use it on Linux SuSe and he don't have any troubles. 


regards
kosha







Hello! 
I have a trouble with PostgreSQL 7.1.3 (and 
7.1.2 too). My OS is Solaris 8x86 with russian locale. PostgreSQL was builded 
from sources and configured with : --enable-locale --enable-multibyte=WIN. 

My problem with sorting lowercase russian 
words in the text fields (type  -  "varchar") after cyrilic 
letter "P". 
create table test (id serial, rubrik varchar 
(255));
Then inserting words in russian (from the 
client written on php  - encoding win1251)
select * from library order by rubriks - will 
cause this problem. 
I think that this problem is only on Solaris 
systems because my friend use it on Linux SuSe and he don't have any troubles. 

 
 
regards
kosha
Tue, 9 Oct 2001 08:58:46 +0400
"Korshunov Ilya" <kosha@kp.ru>
Problem with cyrilic
Ilya,

check your system locale - does simple perl script works properly

	Oleg
On Tue, 9 Oct 2001, Korshunov Ilya wrote:

> Hello!
> I have a trouble with PostgreSQL 7.1.3 (and 7.1.2 too). My OS is Solaris 8x86 with russian locale. PostgreSQL was builded from sources and configured with : --enable-locale --enable-multibyte=WIN.
> My problem with sorting lowercase russian words in the text fields (type  -  "varchar") after cyrilic letter "P".
> create table test (id serial, rubrik varchar (255));
> Then inserting words in russian (from the client written on php  - encoding win1251)
> select * from library order by rubriks - will cause this problem.
> I think that this problem is only on Solaris systems because my friend use it on Linux SuSe and he don't have any troubles.
>
>
> regards
> kosha
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Tue, 9 Oct 2001 21:06:45 +0300 (GMT)
Oleg Bartunov <oleg@sai.msu.su>
Re: Problem with cyrilic