Re: R: Re: Chinese in Postgres
От | Hannu Krosing |
---|---|
Тема | Re: R: Re: Chinese in Postgres |
Дата | |
Msg-id | 520E1ED9.7080703@2ndQuadrant.com обсуждение исходный текст |
Ответ на | R: Re: Chinese in Postgres ("ciifrancesco@tiscali.it" <ciifrancesco@tiscali.it>) |
Список | pgsql-hackers |
On 08/16/2013 02:40 PM, ciifrancesco@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Ü
В списке pgsql-hackers по дате отправления: