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.
signature.asc
Description: Digital signature
