Re: [HACKERS] Chinese in Postgres

2013-08-18 Thread Nicolas Barbier
[ Could you please trim your citations, i.e., please don’t top-post: https://en.wikipedia.org/wiki/Posting_style#Top-posting ] 2013/8/16 Francesco : > Thanks for your answer. > Yes, the client is also UTF8: > > MyDB=# show > client_encoding; > client_encoding > - > UTF8 > (1 row)

Re: [HACKERS] Chinese in Postgres

2013-08-17 Thread Peter Geoghegan
On Fri, Aug 16, 2013 at 4:25 AM, ciifrance...@tiscali.it wrote: > 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

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

2013-08-16 Thread Song
ql-ru-gene...@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-

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

2013-08-16 Thread ciifrance...@tiscali.it
"ciifrance...@tiscali.it" , "ha...@2ndquadrant.com" Cc: "pgsql-hackers@postgresql.org", "pgsql-zh-gene...@postgresql.org", "pgsql-ru-gene...@postgresql.org" Ogg: 回复: [pgsql-zh-general] R: Re: [HACKERS] Chinese in Postgres maybe your C++ program

R: Re: [HACKERS] Chinese in Postgres

2013-08-16 Thread ciifrance...@tiscali.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: ha...@2ndquadrant.com Data: 16/08/2013 14.16 A: "ciifrance...@tiscali.it" Cc: , , Ogg: Re: [HACKER

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

2013-08-16 Thread Hannu Krosing
On 08/16/2013 02:40 PM, ciifrance...@tiscali.it wrote: > Thanks for your answer. > Yes, the client is also UTF8: > > MyDB=# show > client_encoding; > client_encoding > - > UTF8 > (1 row) Strange, it works for me : hannu@hannu-900X3E:~/workspace/my-app$ psql psql (9.3beta2, serve

Re: [HACKERS] Chinese in Postgres

2013-08-16 Thread Hannu Krosing
On 08/16/2013 01:25 PM, ciifrance...@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 form

[HACKERS] Chinese in Postgres

2013-08-16 Thread ciifrance...@tiscali.it
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,