By looking at error it seems that database encoding is different in mysql
database.
By default db encoding in PostgreSQL is UTF-8. You can set client_encoding by
set client_encoding =
You can check the Mysql database encoding using following command.
show variables like "character_set_data
Hi Adarsh,
There are very good tools out for migration from Mysql to PostgreSQL.
EnterpriseDB has the migration studio which will help to migrate Mysql to
PostgreSQL.
http://www.enterprisedb.com/solutions/mysql-vs-postgresql/how-to-move-from-mysql-to-postgresql
Best Regards,
Raghavendra
Enterpri
