2011/3/1 Adarsh Sharma <adarsh.sharma@stripped>:
> Dear all,
>
> I want to convert some tables from Mysql database to Postgresql Database in
> Linux Systems ( Ubuntu-10.4, CentOS ).
[...]
> invalid byte sequence for encoding "UTF8": 0xe3ba27
> HINT: This error can also happen if the byte sequence does not match the
> encoding expected by the server, which is controlled by "client_encoding".
> ERROR: invalid byte sequence for encoding "UTF8": 0xee6c65
> HINT: This error can also happen if the byte sequence does not match the
> encoding expected by the server, which is controlled by "client_encoding".
> ERROR: invalid byte sequence
This is not a MySQL-specific error. You are using a character set
encoding as if it were another. Please, check documentation for the
options to export and import database dumps such as:
<http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html#option_mysqldump_default-character-set>
--
Jaime Crespo
MySQL & Java Instructor
Software Developer
Warp Networks
<http://warp.es>
