Re: BUG #1985: cannot insert Chinese character into a table encoded with UTF8

""Jeff Tong"" <jeff(at)tong(dot)cc> wrote
>
> The following bug has been logged online:
>
> Bug reference: 1985
> Logged by: Jeff Tong
> Email address: jeff(at)tong(dot)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