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: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster