R: Re: [HACKERS] Chinese in Postgres

From: "ciifrancesco(at)tiscali(dot)it" <ciifrancesco(at)tiscali(dot)it>
To: <hannu(at)2ndQuadrant(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-zh-general(at)postgresql(dot)org>, <pgsql-ru-general(at)postgresql(dot)org>
Subject: R: Re: [HACKERS] Chinese in Postgres
Date: 2013-08-16 12:40:09
Message-ID: 22641734.19061376656809198.JavaMail.defaultUser@defaultHost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-ru-general pgsql-zh-general

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

--
Hannu Krosing
PostgreSQL Consultant
Performance,
Scalability and High Availability
2ndQuadrant Nordic OÜ

--
Sent via
pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)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/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2013-08-16 12:45:13 Re: R: Re: [HACKERS] Chinese in Postgres
Previous Message Hannu Krosing 2013-08-16 12:16:24 Re: Chinese in Postgres

Browse pgsql-ru-general by date

  From Date Subject
Next Message Hannu Krosing 2013-08-16 12:45:13 Re: R: Re: [HACKERS] Chinese in Postgres
Previous Message Hannu Krosing 2013-08-16 12:16:24 Re: Chinese in Postgres

Browse pgsql-zh-general by date

  From Date Subject
Next Message Hannu Krosing 2013-08-16 12:45:13 Re: R: Re: [HACKERS] Chinese in Postgres
Previous Message Hannu Krosing 2013-08-16 12:16:24 Re: Chinese in Postgres