> 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 database cluster and a database instance using the -E EUC_CN > option. The database ran OK: I could successfully save and retrieve > Chinese(GB2312) from some test database tables. However, when I tried to > select data from a table with Chinese (GB2312) data with an "order by" > clause, the outcome indicate that the "order by" instruction had no > effect. > Do you know if sorting Chinese data works in Postgresql 7.3.1? If yes, > how would I get it to work? If no, what can be done? I am willing to > help to get this work if there is not someone already working on it.
That might be a Chinese locale problem. Try re-initdb with --no-locale option to disable the locale support. Unfortunately there's no way to build PostgreSQL 7.3 or later without locale support except specify the option at initdb time. -- Tatsuo Ishii ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly