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

""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

Jeff Tong 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

Strange. We thought we fixed all the UTF-8/Chinese issues in 8.1. Can
you tell us the Unicode byte code sequence that is being rejected?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

How can I search the Unicode byte code seqence?

There is a Unified CJK Ideographs in the following website:
http://www.unicode.org/charts/

I chose some characters within that pdf file but none of them
can be inserted into utf8 encoded table.

I took another screenshot from latest 8.1 beta 4:
http://www.tong.cc/pgsql8.1beta3_2.png

Tell me more if I can help.