Load Mysql table CSV into postgresql

[Adarsh Sharma <eddy.adarsh@xxxxxxxxx>]

Hi,

Today i  need to load some mysql ( 5.1.58 ) tables dump in postgresql ( PG 9.2 ). I loaded few tables successfully but while loading one table i am facing below error :

test=# copy jobs from '/tmp/test.csv' with DELIMITER AS  ',' QUOTE '"' NULL AS '\N' ESCAPE E'\\' CSV;
ERROR:  invalid byte sequence for encoding "UTF8": 0xc7 0x3c
CONTEXT:  COPY jobs, line 259

After some research , i think it is failing because Mysql table has character set latin1 format and PG9.2 has by deafult UTF-8 format. But don't understand how other tables got successfully loaded. Below link tells to use iconv :

http://www.perlmonks.org/?node_id=942765 , but still the same error.

My doubt is in this table there is one MEDIUMBLOB that i used as BYTEA in postgresql. Is it was due to that or anyone fixed this issue earlier , plz update.

Thanks