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

Reply via email to