[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:
mark3536@yahoo.cn
Data: 16/08/2013 14.52
A: "ciifrancesco@tiscali.it"
<ciifrancesco@tiscali.it>, "hannu@2ndQuadrant.com"<hannu@2ndQuadrant.
com>
Cc: "pgsql-hackers@postgresql.org"<pgsql-hackers@postgresql.org>,
"pgsql-zh-general@postgresql.org"<pgsql-zh-general@postgresql.org>,
"pgsql-ru-general@postgresql.org"<pgsql-ru-general@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
________________________________
发件人：
"ciifrancesco@tiscali.it" <ciifrancesco@tiscali.it>
收件人：
hannu@2ndQuadrant.com
抄送： pgsql-hackers@postgresql.org; pgsql-zh-
general@postgresql.org; pgsql-ru-general@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:
hannu@2ndQuadrant.com
Data: 16/08/2013 14.16
A: "ciifrancesco@tiscali.
it"
<ciifrancesco@tiscali.it>
Cc: <pgsql-hackers@postgresql.org>,
<pgsql-zh-
general@postgresql.org>, <pgsql-ru-general@postgresql.org>
Ogg: Re:
[HACKERS] Chinese in Postgres
On 08/16/2013 01:25 PM,
ciifrancesco@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-
hackers@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/
