Thread: R: 回复: [pgsql-zh-general] R: Re: Chinese in Postgres

R: 回复: [pgsql-zh-general] R: Re: Chinese in Postgres

From
"ciifrancesco@tiscali.it"
Date:
[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/