Re: Chinese in Postgres

On 08/16/2013 01:25 PM, ciifrancesco(at)tiscali(dot)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Ü