Importing Mac files into MySQL

[Grizzly]

I'm having some serious problems with foreign characters while importing CSV files from Mac into mySQL running in a Linux Machine.

Do anyone know how to convert a text file encoded in Mac to a Linux or Windows encoding?

Ordinarily I would load the Mac into Windows Excel (or OpenOffice), convert to Windows Format and upload the file to mysql using LOAD DATA.

The problem is that this process is too long because the client has to export from Filemaker to CSV, import to Excel, save in windows format, and then upload the file though a PHP backend, several times a day.

I'm trying to cut some of the steps, so it takes less time. Ideally one would export from filemaker to CSV in Mac, and upload directly to mysql via PHP backend. But this way, the foreign characters are not displayed correctly on the browser.

Can anyone help?

thanks!

[jsim]

Try this:
http://www.softclub.org/excelexplorer/

In "Demo" section you can find online demo version of this script.
Try it with your own file and find out if this is what you need.