I used mysqldump to dump the data from a MySQL 8.0 database which I am moving into my 19c adb.

I am doing this on oraclelinux.

When I use the file command on the txt file generated by mysqldump I see that it is UTF-8 unicode. if I look at the sql file that was generated by mysqldump it says that the MySQL database is using UTF8mb4 as its default characterset.

My adb is using AL32UTF8 as the database characterset.

When I use sql loader to load the data into the adb, some characters get mangled.

So my question is what characterset should I use in my sql loader control file? I have tried we8iso8859p1 but that doesn't work.

btw: my linux shell is using AMERICAN_AMERICA.AL32UTF8 as its NLS_LANG environment variable.

After a lot of googling I haven't found a good list of possible charactersets for sql loader.

MySQL data: Financière

Oracle ADB data: Financière