| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | stevegy <stevegy(at)126(dot)com> |
| Cc: | "pgsql-general(at)postgr" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Hi,&nbs |
| Date: | 2006-10-04 14:35:41 |
| Message-ID: | 20061004143541.GC7063@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Talha Khan | 2006-10-04 19:32:56 | Re: storing transactions |
| Previous Message | A. Kretschmer | 2006-10-04 14:27:28 | Re: Fwd: Help with function |