Data Corruption from Database Table Fetch

Question

Hi,

I am working with some MySQLdatabase integrating with JMP 12. (No I cannot afford to upgrade).

I am seeing some data corruption when I import a table.

Using MySQLWorkbench to view the data.  Notice the first 2 rows id = A01B and its associated title and compare it to the JMP table.  The id value is trunctated and title is missing.  In row 2, A01C, the title value is corrupt.

Is this a known issue and is there a work around?

Dahlia_Watkins · Answer

This behavior is only experienced using ANSI ODBC drivers. We only support ODBC 3.5 Unicode compliant drivers per our System Requirements.

Wendy_Murphrey · Answer

Good morning,

Please forward your request to JMP Technical Support (support@jmp.com).  We will be glad to look into this issue with you.