[I reply to both in one email] Song: that C++ program has a log file. In the log file the queries look like this: UPDATE MY_table SET UTF8_field = '<e5><8f><b0><20><31><32><33><34><27><20><57><48><45><52><45><20><49><44><20><3d><20><31>
starting from the first chinese letter, all the rest of the query is in hexa. But this is not a problem, because the query is inserted fine (excepted the chinese letter). And if i use a hexa converter, i get the correct query: UPDATE MY_table SET UTF8_field = '台 1234' WHERE ID = 1 Hannu: the length in the database is counting each of the empty squares: UTF8_field | length ------------+-------- ��� 1234 | 8 cheers Francesco ----Messaggio originale---- Da: mark3...@yahoo.cn Data: 16/08/2013 14.52 A: "ciifrance...@tiscali.it" <ciifrance...@tiscali.it>, "ha...@2ndquadrant.com"<hannu@2ndQuadrant. com> Cc: "pgsql-hackers@postgresql.org"<pgsql-hackers@postgresql.org>, "pgsql-zh-gene...@postgresql.org"<pgsql-zh-gene...@postgresql.org>, "pgsql-ru-gene...@postgresql.org"<pgsql-ru-gene...@postgresql.org> Ogg: 回复： [pgsql-zh-general] R: Re: [HACKERS] Chinese in Postgres maybe your C++ program has something (such as charset or configuation) causing this strange thing mark ________________________________ 发件人： "ciifrance...@tiscali.it" <ciifrance...@tiscali.it> 收件人： ha...@2ndquadrant.com 抄送： pgsql-hackers@postgresql.org; pgsql-zh- gene...@postgresql.org; pgsql-ru-gene...@postgresql.org 发送日期： 2013年8月16 日, 星期五, 8:40 下午 主题: [pgsql-zh-general] R: Re: [HACKERS] Chinese in Postgres Thanks for your answer. Yes, the client is also UTF8: MyDB=# show client_encoding; client_encoding ----------------- UTF8 (1 row) Cheers Francesco ----Messaggio originale---- Da: ha...@2ndquadrant.com Data: 16/08/2013 14.16 A: "ciifrancesco@tiscali. it" <ciifrance...@tiscali.it> Cc: <pgsql-hackers@postgresql.org>, <pgsql-zh- gene...@postgresql.org>, <pgsql-ru-gene...@postgresql.org> Ogg: Re: [HACKERS] Chinese in Postgres On 08/16/2013 01:25 PM, ciifrance...@tiscali.it wrote: > Hello all, > before writing this message, I wrote about this in other mailing lists > without solving my problem. > Maybe some of you can help me. > > I have problems with a DB in postgres, when i try to insert Chinese > strings in UTF-8 format. > If I insert the data using a C++ program I have empty squares, in this > format: ��� (3 empty squares for each chinese ideogram as that is the > length in UTF-8) > If the string contains chinese mixed with ASCII, the ASCII is OK but > the Chinese is broken: > 漢語1-3漢語 --> ������1- 3������ Can you cehck that your client encoding is also UTF8 hannu=# show client_encoding ; client_encoding ----------------- UTF8 (1 row) Cheers -- Hannu Krosing PostgreSQL Consultant Performance, Scalability and High Availability 2ndQuadrant Nordic OÜ -- Sent via pgsql-hackers mailing list (pgsql- hack...@postgresql.org) To make changes to your subscription: http: //www.postgresql.org/mailpref/pgsql- hackers Invita i tuoi amici e Tiscali ti premia! Il consiglio di un amico vale più di uno spot in TV. Per ogni nuovo abbonato 30 € di premio per te e per lui! Un amico al mese e parli e navighi sempre gratis: http://freelosophy.tiscali.it/ -- Sent via pgsql-zh-general mailing list (pgsql-zh-general@postgresql. org) To make changes to your subscription: http://www.postgresql. org/mailpref/pgsql-zh-general Invita i tuoi amici e Tiscali ti premia! Il consiglio di un amico vale più di uno spot in TV. Per ogni nuovo abbonato 30 € di premio per te e per lui! Un amico al mese e parli e navighi sempre gratis: http://freelosophy.tiscali.it/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
