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@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
