Thank you for the post.
“MySQL ODBC 5.3 ANSI driver version 5.03.0004 (32 bit)”
The recommended driver for this process is Actual Open Source 3.2.0 per this knowledge base article:
What is the version of MySQL? Does this still happen if using the tested version of the driver? Is FileMaker Pro 13 on the same computer as the SQL source?
“I formerly used ODBC manager but after a while this only returned three lines per request which made it useless for me.”
This is a limitation of the free trial version of the driver that is removed when purchased.
Here’s the link for to the driver: http://www.actualtech.com/download.php
I'm having a similar problem in FM 14/15, El Capitan, MySQL Unicode Drive 5.3
It doesn't crash but I can't get it to create a table occurrence in the relationship graph. I get the error "This action cannot be performed because the required table is missing". This is strange as I can see and select the table. The ANSI version works fine, but I need Unicode as some of our data contains special characters only found in Unicode. The ANSI driver errors when I try to put in a special character.
I tried the Actual driver for Open Databases but it doesn't seem to support Unicode either.
The MySQL ODBC 5.2 Unicode Driver version 5.2.7 (either 32-bit or 64-bit) are the only supported versions for Windows. For Mac, only the Actual Technologies drivers are supported. See Knowledge Base Article #6420:
Have you talked to Actual Technologies about a Unicode driver?
I've submitted a support ticket to them.
Is it possible it's not the driver? When I connect with the Actual Driver (ESS) I can see the special characters but when I try and update that field I get an error or it writes up to the first special character and the rest gets truncated.
It is possible the driver is not the issue. However, FileMaker, Inc. and Actual Technologies have a good relationship. Once Actual Technologies investigates, they will let us know where the issue resides and the cause.
Thought I'd follow up.
The fields in MySQL were set to Latin1 collation Swedish. (Why Swedish I haven't a clue.) I changed the one's that need Unicode to UTF8 and I can now save Unicode data in these fields.
However the Actual driver, seems very buggy compared to the native MySQL one. It keeps putting up a blank white square which I assume is some kind of error message with the text missing. Then it gives the Apple Command symbol with the period for a few seconds then brings up the blank white box again. It does this over and over for minutes. It even caused FM to crash once.
This maybe because I'm using the evaluation version of the driver that's limited to 3 records. It would be good to know if this is going to be a problem before purchasing the driver. I'll contact Actual and see what they say.
Okay Last followup.
FileMaker really, really doesn't like the trial Actual Driver that limit's queries to 3 records.
Actual sent me a link where I can register for a 30 day trial license key that has no limits on the number of records returned. So far the 30 day trial is working perfectly.
thank you for the followup, brian!