From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | songhe(at)optonline(dot)net |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Sorting Chinese data in Postgresql 7.3.1 |
Date: | 2003-01-27 01:12:49 |
Message-ID: | 20030127.101249.59653609.t-ishii@sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-01-27 01:38:38 | Re: Request for qualified column names |
Previous Message | Bradley Baetz | 2003-01-27 01:07:58 | Re: New hashed IN code ignores distinctiveness of subquery |