Thread: BUG #1985: cannot insert Chinese character into a table encoded with UTF8
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
Re: BUG #1985: cannot insert Chinese character into a table encoded with UTF8
From
"Qingqing Zhou"
Date:
""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. >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? > > >