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, server 9.2.4) Type "help" for help. hannu=# select * from pg_stat_activity; hannu=# show client_encoding ; client_encoding ----------------- UTF8 (1 row) hannu=# create table tchinese(data text); CREATE TABLE hannu=# insert into tchinese values('漢語1-3漢語'); INSERT 0 1 hannu=# select * from tchinese ; data ------------- 漢語1-3漢語 (1 row) hannu=# \q Are you sure that the client-encoding is also the same when you are actually doing the import ? Or when you are getting the wrong results when reading what does length() of the bad field give you ? hannu=# select data, length(data) from tchinese ; data | length -------------+-------- 漢語1-3漢語 | 7 (1 row) -- 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