MS Access to MySQL truncation problem

[Derr Gill]

Hello,

I am trying to use some third party software (Bullzip) to convert my MS Access database to a .sql file I can load into MySQL from the Windows command prompt.

Thusfar the main problem I am having is related to collation and character sets. I want the MySQL db to be unicode, and the MS Access db is latin1. So I get an error 1366 when I try to import the file, unless I turn off strict mode.

However, when I disable strict mode, though I get no errors during the import, when I go back and look at the new tables in the MySQL database, any text that follows a special European character (for an A with an accent over it), that character and everything else following it in that field for that record is truncated.

How can I make MySQL accept the latin1 db without any truncation, and still have the final result be unicode?

Thank you for any help