Re: R: Re: [HACKERS] Chinese in Postgres

Does your client have the Chinese fonts to display Chinese characters?
It looks more like font problem.

于 2013/8/16 20:40, ciifrancesco(at)tiscali(dot)it 写道:
> 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(at)2ndQuadrant(dot)com
>
> Data: 16/08/2013 14.16
> A: "ciifrancesco(at)tiscali(dot)it"
> <ciifrancesco(at)tiscali(dot)it>
> Cc: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-zh-
> general(at)postgresql(dot)org>, <pgsql-ru-general(at)postgresql(dot)org>
> Ogg: Re:
> [HACKERS] 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
>
>