Re: BUG #1985: cannot insert Chinese character into a table encoded with UTF8 - Mailing 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