convert text data from latin1 to utf8

[Cheryl Chase]

I am using mysql to clean up some data exported from FileMaker Pro on a Mac (character set latin1, I think). After cleanup in mysql, I use phpmyadmin to dump the data as sql, and it is imported into Salesforce.com using their data loader tool.

Accented characters etc. are broken after import.

I believe that I need to convert the text data from latin1 to utf8 before handing it to the salesforce.com import tool.

I am exporting the data from Filemaker Pro into tab separated text, and importing into mysql 5.0.19-standard under OSX like so:

LOAD DATA INFILE "names.tsv" INTO TABLE names FIELDS TERMINATED BY '\t';


How can I get UTF8 out of mysql?

Thanks,


Cheryl