Page 1 of 1

invalid byte sequence for encoding "UNICODE": 0xe3

Posted: Mon Feb 07, 2005 11:53 pm
by anjanesh
PostgreSQL :

Code: Select all

UPDATE "Country" SET "DialingCode"='239' WHERE "Name"='São Tomé and Principe';
Anyone one know how to get rid of this error ?
ERROR: invalid byte sequence for encoding "UNICODE": 0xe36f20

The default table type in MySQL is MyISAM. There are too many types in PostgreSQL. The default was set to LATIN which I changed to UNICODE.
I changed from LATIN because I thought it has something to do with the language.
Thanks

Posted: Mon Feb 07, 2005 11:56 pm
by feyd
the string you are passing in doesn't look like unicode.. just a standard extended ascii string.

Posted: Tue Feb 08, 2005 1:01 am
by anjanesh
So what should be the table format if I need to insert such characters ?