R: Re: [HACKERS] Chinese in Postgres
От | ciifrancesco@tiscali.it |
---|---|
Тема | R: Re: [HACKERS] Chinese in Postgres |
Дата | |
Msg-id | 22641734.19061376656809198.JavaMail.defaultUser@defaultHost обсуждение исходный текст |
Ответы |
Re: R: Re: [HACKERS] Chinese in Postgres
Re: [HACKERS] Chinese in Postgres |
Список | pgsql-ru-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@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/
В списке pgsql-ru-general по дате отправления: