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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

""Jeff Tong"" <jeff (AT) tong (DOT) cc> wrote
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



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly