invalid byte sequence for encoding "UNICODE": 0xe3

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

invalid byte sequence for encoding "UNICODE": 0xe3

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

the string you are passing in doesn't look like unicode.. just a standard extended ascii string.
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post by anjanesh »

So what should be the table format if I need to insert such characters ?
Post Reply