6 Replies Latest reply on Aug 1, 2013 7:19 AM by LSNOVER

    Incorrect text characters showing from ESS MySQL source

    pthomas

      Hello everyone,

       

      We have just finished upgrading our databases to FileMaker 12 and are now experiencing some issues with the display of data from a MySQL database.

       

      This is how the information looks in the MySQL database:

       

      Capture.JPG

       

      And this is how it looks when I put the MySQL field onto a FileMaker layout:

       

      Capture1.JPG

       

      As part of the FileMaker upgrade we also needed to upgrade our Actual ODBC driver (the old one didn't support 32 bit) so now I am unsure if the issue is with the Actual ODBC driver, or FileMaker itself...

       

      We are running a Mac server, and have a mixture of Mac and PC clients (all of which display the data incorrectly).

       

      FileMaker server version: 12.0.4.405

      FileMaker Pro Advanced version (installed on all clients): 12.0v4

      Actual ODBC driver version: Actual Open Source Databases 3.1.16 (MySQL, PostgreSQL and SQLite)

       

      Has anyone else come across this issue?

       

      Cheers,

       

      Paul.