Re: Sorting Chinese data in Postgresql 7.3.1 - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Sorting Chinese data in Postgresql 7.3.1
Date
Msg-id 20030127.130603.15268926.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Sorting Chinese data in Postgresql 7.3.1  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
> 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 bug with the man page. Try initdb --help to find the option.

> Could you point me to the source codes where I can pin down
> this? 

No idea at this point. What about the results of following SQL?


SELECT 'chinese char1'::text > 'chinese char2'::text;

Do you get same result for any Chinese (EUC_CN) characters?
--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: Justin Clift
Date:
Subject: Re: [CYGWIN] Have a PG 7.3.1 Windows (cygwin) easy installer... now
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Can we revisit the thought of PostgreSQL 7.2.4?