Copy product catalog to MySQL with special characters

April 7, 201312 yr

I am writing a script to periodically update my product catalog in MySQL using data from FileMaker.

The MySQL tables have been added to the file. The encoding of the MySQL tables is UTF-8.

The method I am using right now is:

1) Find records that I want to be copied to MySQL

2) Go to layout of MySQL table

3) Import records

This works well in most cases but problems occur if the product contains a special character like "™".

"511™ Slim Fit Jeans" goes into the MySQL text field properly if viewed from Sequel Pro, but in FileMaker, it reads back in as "511 1 1 1 1 1 1 1 1 1 1 1 1".

Another example: If I type "Sample™ Product" in a MySQL table in FileMaker, it will read back in as "Sample e e e e".

Also, if I attempt to edit these records in FileMaker, I get the error message, "This record was modified by another user since you started editing it. Do you want to save your changes anyway and possibly overwrite their changes?"

What's going on here?