| From: | Weiping <laser(at)qmail(dot)zhengmai(dot)net(dot)cn> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | PGCLIENTENCODING behavior of current CVS source | 
| Date: | 2004-11-16 08:39:04 | 
| Message-ID: | 4199BCA8.30803@qmail.zhengmai.net.cn | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
hi,
I'm using CVS source built postgres, may be one day later
then the main site, but found one problem:
I've set PGCLIENTENCODING environment before, for easy of
typing, like export PGCLIENTENCODING=GBK in my .profile,
but after I upgrade my postgresql to current CVS, I found
problem, the database initialized using:
initdb --locale=zh_CN.utf8 ...
the database connected is UNICODE encoded, but when I
use psql to loging to one of my database, it response:
psql: FATAL: invalid value for parameter "client_encoding": "GBK"
but when I remove the PGCLIENTENCODING setting:
unset PGCLIENTENCODING,
now I can login, but when I do a:
DHY_JJG=# \dt
ERROR: invalid byte sequence for encoding "UNICODE": 0xed
but, after:
DHY_JJG=# \encoding gbk
DHY_JJG=#\dt
woule be ok. the LANG setting is zh_CN.gbk, I guess it's
a localization problem. may be the encoding of thos po files.
because while using psql -E we see the query contain the
locale string in AS clause, but don't know the best way to
fix that, may be use UNICODE to encode those po files?
regards
Laser
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joolz | 2004-11-16 09:01:24 | Re: OID's | 
| Previous Message | Michael Fuhr | 2004-11-16 07:29:58 | Re: table configuration tweak for performance gain. |