Hi, All, I create a database which encoding is UTF8, and create a table test create table test ( name varchar); I insert a data '\244\350' encoding is Big5, I wish translate them to UTF8, so I use insert into test values ('convert('\244\350' using big5_to_utf_8)); I got an error: ERROR: invalid byte sequence for encoding "UNICODE": 0xe8; How could I do for this problem? any ideas.
Alex CS Huang ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match