Skip site navigation (1) Skip section navigation (2)

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

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1985: cannot insert Chinese character into a table encoded with UTF8
Date: 2005-10-24 04:56:45
Message-ID: djhpi7$b5s$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
""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 



In response to

pgsql-bugs by date

Next:From: Jari AaltoDate: 2005-10-24 09:34:11
Subject: Re: BUG #1986: Please include ONE BIG .txt and .HTML file in *docs*.tar.gz
Previous:From: NicholasDate: 2005-10-24 01:03:22
Subject: BUG #1994: Ignore the last bug report; this is a confusing time zone feature, not a bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group