Migration from ORACLE to MySQL - CLOB

------_=_NextPart_001_01CB925F.39F27F55
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I need to migrate about a dozen tables from ORACLE 10g to MySQL 5. I
have manually migrated the schema to MySQL. I am able to write SQL*PLUS
queries to extract ORACLE data into insert statements (including date
conversions to MySQL format etc) that I can run against the MySQL
database. The CLOB fields are tripping me because of single quotes,
double quotes and carriage returns in the data.=20
=20
I can possibly change all single quotes to two single quotes and double
quotes to two double quotes and MySQL will be happy ingesting that data
into TEXT fields.
The carriage returns are breaking the lines when the SQL*PLUS data is
spooled into a flat file.
=20
How can I deal with quotes and carriage returns in CLOB data?
=20
Thanks,
Rajesh
=20

------_=_NextPart_001_01CB925F.39F27F55--