importing utf data from external to FMP

[levonk]

Hi,

I am using FMP 9 advanced. I have an external table that I need to import into FM tables so I can use them in Value Lists. The data is on a MySQL server, and I need only two fields (ID and Name).

The Id is importing without problems. The name is a utf8 column. It shows correctly when accessed from MySQL. If there are characters other that roman it that field, the imported field contains question marks instead of the text. I am using the Import Records from ODBC with SELECT.

I found a workaround, which is not that good but it does the job. I export the data to a tab delimited file with utf16 (utf8 is not working), and then I import the data from that file.

Is this a problem with the SQL in FMP or is there something I am doing wrong?

[levonk]

I tried the same script on a friend's windows XP machine and it worked fine.

So, is the problem with FMP for mac? Or is it possible that MySQL does not function correctly on Mac?