By default Postgresql database encoding in UTF8.
It seems to me by seeing error that database encoding in mysql is
different from it.
--
Cheers,
Dhaval Jaiswal
On 01/03/2011 3:57 PM, Adarsh Sharma wrote:
Dear all,
I want to convert some tables from Mysql database to Postgresql
Database in Linux Systems ( Ubuntu-10.4, CentOS ).
Can someone Please tell me tool for it that makes it easier.
I am able to done it through FW tools in Windows System but i want to
achieve it in Linux ( CentOS ) System.
I researched a lot & tried below steps :
1. mysqldump --compatible=postgresql wiki20100130 >
/hdd4-1/wiki20100130_mysql108feb22.sql
2. sed "s/\\\'/\'\'/g" wiki20100130_mysql108feb22.sql
3. bin/psql -Upostgres wiki20100130 <
/hdd4-1/wiki20100130_mysql108feb22.sql
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
I think a tool would ease that work.
Thanks & best Regards,
Adarsh Sharma
<font Face='Arial' style='font-size:9pt'>This e-mail, and any attachments are
strictly confidential and may also contain legally privileged information. It is
intended for the addressee(s) only. If you are not the intended recipient, please do
not print, copy, store or act in reliance on the e-mail or any of its attachments.
Instead, please notify the sender immediately and then delete the e-mail and any
attachments.
Unless expressly stated to the contrary, the views expressed in this e-mail are not
necessarily the views of Enzen Global Solutions (P) Limited or any of its
subsidiaries or affiliates (Group Companies), and the Group Companies, their
directors, officers and employees makes no representation and accept no liability for
the accuracy or completeness of this e-mail. You are responsible for maintaining your
own virus protection and the Group Companies do not accept any liability for viruses.
Enzen reserves the right to monitor and review the content of all messages sent to or
from this e-mail address. Messages sent to or from this e-mail address may be stored
on the Enzen e-mail system.</font>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org