Eureka.
The problem is solved.
Bambo:
> I guess you forget to convert
you string to UTF-8 before insert.
No, too many conversions :)
The
fact is that in the source code the query was casted to UnicodeString,
because of previous requirements on the project:
//tmp is a char* and
contains the
TE MY_table SET UTF8_field = '台 1234' WHERE ID = 1
Hannu:
the length in the database is counting each of the empty
squares:
UTF8_field | length
----+----
��� 1234
| 8
cheers
Francesco
Messaggio originale
Da:
mark3...@yahoo.cn
Data: 16/08/2013 14.52
A:
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
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,
