Re: BUG #1985: cannot insert Chinese character into a table encoded with UTF8 - Mailing list pgsql-bugs

From Qingqing Zhou
Subject Re: BUG #1985: cannot insert Chinese character into a table encoded with UTF8
Date
Msg-id djhpi7$b5s$1@news.hub.org
Whole thread Raw
In response to BUG #1985: cannot insert Chinese character into a table encoded with UTF8  ("Jeff Tong" <jeff@tong.cc>)
List pgsql-bugs
""Jeff Tong"" <jeff@tong.cc> wrote
>
> The following bug has been logged online:
>
> Bug reference:      1985
> Logged by:          Jeff Tong
> Email address:      jeff@tong.cc
> PostgreSQL version: 8.1beta3
> Operating system:   Windows XP
> Description:        cannot insert Chinese character into a table encoded
> with UTF8
> Details:
>
> I am a traditional Chinese user in Hong Kong. 8.1beta3 for WinXP still
> cannot let me insert Chinese character into a table encoded with UTF8. I
> think it is very importance issue with CJK users who need Unicode encoded
> tables.
>
> Here is a screenshot I took from command prompt:
> http://www.tong.cc/pgsql8.1beta3.png
>

This is not a bug and it is answered several times before. It is the
incorrect setting of client_encoding. Just iterate the solution here:

    test#\encoding LATIN_1

Then it works.

Regards,
Qingqing

pgsql-bugs by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: BUG #1988: keygen not implemented
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #1970: Existing /etc/pam.d/postgresql clobbered by RPM