BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Highlighted
Hegedus

Community Trekker

Joined:

Jun 23, 2011

Data Corruption from Database Table Fetch

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.

MySQLWorkbench View.pngJMP View.png

 

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

2 REPLIES 2
Wendy_Murphrey

Joined:

Jun 23, 2011

Re: Data Corruption from Database Table Fetch

Good morning,

 

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

Wendy
Dahlia_Watkins

Joined:

Jan 24, 2017

Re: Data Corruption from Database Table Fetch

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