Re: [HACKERS] Sorting Chinese data in Postgresql 7.3.1

2003-01-26 Thread Tatsuo Ishii
Tatsuo, I have been trying to get the sorting of Chinese data in Postgresql 7.3.1 to work without much success. Here is what I did. I rebuilt the executables with ./configure -enable-multibyte=ENC_CN on a RedHat Linux 8.0 Pentium 2 system. The build was successful. I created a test

Re: [HACKERS] Sorting Chinese data in Postgresql 7.3.1

2003-01-26 Thread Tatsuo Ishii
I tried initdb -E EUC_CN --no-locale and tested order by with the same Chinese data, I got the same result: the order by clause does not have any effect. The locale on my Redhat Linux 8.0 is en_US.UTF-8. By the way, the manual page for initdb does not show an option --no-locale. That's a