Migration Oracle to Mysql 5

Hello,

I tried to migrate a database from Oracle 8.1.7.4 to Mysql 5.0.22.
I use the software Mysql Migration Toolkit.
I have 2 problems :

- The mysql files given by Migration Toolkit don't contain character with accent (french
characters). But i use latin1 character set to generate this files. I don't understand where is the
problem ?

- The file generated by Migration Toolkit give lowercase character for the name of table and field
of table. But i need to have them with uppercase. I see a solution : i have to modify
MigrationOracle.java file of Migration Toolkit and recompile it. But it is very heavy. Do you know
an other solution ?

Thanks for your help.

Yo Man wrote:
> Hello,
>
> I tried to migrate a database from Oracle 8.1.7.4 to Mysql 5.0.22.
> I use the software Mysql Migration Toolkit.
> I have 2 problems :
>
> - The mysql files given by Migration Toolkit don't contain character
> with accent (french characters). But i use latin1 character set to
> generate this files. I don't understand where is the problem ?
>
> - The file generated by Migration Toolkit give lowercase character for
> the name of table and field of table. But i need to have them with
> uppercase. I see a solution : i have to modify MigrationOracle.java file
> of Migration Toolkit and recompile it. But it is very heavy. Do you know
> an other solution ?
>
> Thanks for your help.

I find a solution for the problem of characters. I use command ICONV to
convert SQL files.

But, for the problem of uppercase, i don't find ... :-(