On Wed, Oct 04, 2006 at 09:45:26PM +0800, stevegy wrote:
> So, now i stop the postgres: pg_ctl stop -D ./data_euc_cn and start
> it use the UTF-8 encoding data directory: pg_ctl start -D
> ./data_utf8. But the sort result for the Chinese characters is still
> wrong. And I notice that the sort result is diffrent from the
> LANG=zh_CN.GB18030.
You need to do more to change the encoding of a database. The encoding
is fixed at cluster-creation time, so you need to run initdb again to
actually change the locale/encoding.
Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.