Hi Everyone, I'm trying to use JMP to connect to a SQLite db and I'm running into a very funny problem where the text fields in the first few rows of data get mangled, while everything else looks fine.
I'm using JMP 11.2.1 for Mac, running Mac 10.11.6, and I'm using the ODBC available here: SQLite ODBC Driver
I've created a very simple database (attached) to test this issue. When I open JMP, and go to File > Database > Open Table I can see connect to the DSN that I've previously setup in the ODBC, and JMP finds the right table name and all.
When I view the db in the SQLite Manager add-on for Firefox, I see the following:
![12825_pastedImage_1.png 12825_pastedImage_1.png](https://community.jmp.com/t5/image/serverpage/image-id/3766i6904D7485A5ED188/image-size/medium?v=v2&px=400)
which is exactly what I would expect to find. I can also query the table directly using the sqlite3 db api for python, and I can confirm that the entries are as shown:
![12850_pastedImage_5.png 12850_pastedImage_5.png](https://community.jmp.com/t5/image/serverpage/image-id/3767iD0FF77C8167AB3FC/image-size/medium?v=v2&px=400)
Yet, when I try to load this table into JMP, I instead find this:
![12826_pastedImage_2.png 12826_pastedImage_2.png](https://community.jmp.com/t5/image/serverpage/image-id/3768i08112AB1586CFE88/image-size/medium?v=v2&px=400)
Very strange! It's getting the integer and floating point fields correctly, but it only got the first two characters of the label column correctly for the first row, and it truncated the 'd' off the label in row 2.
For completeness, here's the info I have in my ODBC setup:
Driver:
![12848_pastedImage_3.png 12848_pastedImage_3.png](https://community.jmp.com/t5/image/serverpage/image-id/3769i4F75C12EA8D5F0CE/image-size/medium?v=v2&px=400)
DSN:
![12849_pastedImage_4.png 12849_pastedImage_4.png](https://community.jmp.com/t5/image/serverpage/image-id/3770i85A4CB6A07CA4473/image-size/medium?v=v2&px=400)
Any help on this would be much appreciated, I'd really love to be able to use JMP to run queries on SQLite databases.
Thanks,
Mike