I have a FileMaker database linked to an external MySQL data file
using the ESS technique. Several text fields in my FM database
contain European names with accented characters. When I run a script
to update the related MySQL columns with text that happens to contain
accented characters, I get an error like this:
ODBC Error: [Actual][MySQL] Incorrect string value: ‘\xE9 Sud …’ for
column ‘title’ at row 1
As far as I know, the MySQL data columns are set to the default
character set latin1_swedish_ci which supports accents.
This is the first time I have ever used an external SQL data source,
so I'm not sure where to begin troubleshooting this error. Is it in
the setup of the MySQL file? Or is it on the FileMaker side? Any
pointers much appreciated.
The MySQL file is hosted remotely, and I don't have physical access
to that server. Otherwise, my FM file is hosted on Mac OS 10.4 Server
running FMS 10. Clients are a mix of Tiger, Leopard, and Snow Leopard
running FMP 10.
Andre
