> zzhb ([EMAIL PROTECTED]) reports a bug with a severity of 3 > The lower the number the more severe it is. > > Short Description > client_encoding can't support GB18030 encoding in postgresql 7.3.1 > > Long Description > When I insert records using files, psql -f install.sql > > if I set PGCLIENTENCODING=GB18030, psql insert simplifed chinese incorrectly,but if > I set PGCLIENTENCODING=GBK or unset PGCLIENTENCODING,psql insert simplifed chinese > correctly. > > But when I use \encoding GB18030 to insert records in interactive psql,it can insert > simplifed chinese correctly.
If you are setteing PGCLIENTENCODING before starting up postmaster, or you are setting client_encoding in postgresql.conf, then that is a known bug. Currently the fix is in current, but not in the 7.3 stable tree to avoid the backward compatibilty with prior releases. This is due to the fact that libpq calls pg_client_encoding() function which is only available in 7.3 or later if you apply the fix. If you need patches for 7.3.1, I could provie it for you, though they would lose the backward compatibilty with prior releases. > The following is my envirnoment. > > [EMAIL PROTECTED] postgres]$ psql -l > List of databases > Name | Owner | Encoding > -----------+----------+---------- > template0 | postgres | UNICODE > template1 | postgres | UNICODE > test | postgres | UNICODE > (3 rows) > > [EMAIL PROTECTED] postgres]$ > [EMAIL PROTECTED] postgres]$ locale > LANG=zh_CN.GB18030 > LC_CTYPE="zh_CN.GB18030" > LC_NUMERIC="zh_CN.GB18030" > LC_TIME="zh_CN.GB18030" > LC_COLLATE="zh_CN.GB18030" > LC_MONETARY="zh_CN.GB18030" > LC_MESSAGES="zh_CN.GB18030" > LC_PAPER="zh_CN.GB18030" > LC_NAME="zh_CN.GB18030" > LC_ADDRESS="zh_CN.GB18030" > LC_TELEPHONE="zh_CN.GB18030" > LC_MEASUREMENT="zh_CN.GB18030" > LC_IDENTIFICATION="zh_CN.GB18030" > LC_ALL= > [EMAIL PROTECTED] postgres]$ > > > > [EMAIL PROTECTED] root]# uname -a > Linux hbzhang 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux > [EMAIL PROTECTED] root]# > > [EMAIL PROTECTED] root]# pg_ctl --version > pg_ctl (PostgreSQL) 7.3.1 > [EMAIL PROTECTED] root]# > > Sample Code > > > No file was uploaded with this report > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > x1 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
