Query base64 data from SQL into the jmp table

Question

Hi,

I'm trying to import base64 encoded data into JMP, but it seems to be truncating the data at 255 characters. The database column containing the base64 string has a length of 546,168 characters. Is there a way to increase the character limit for the jmp table column?

Thanks,

Jackie

Craige_Hales · Answer

Welcome, and which part worked for you? Thanks for any details you can share. Everybody struggles with database connections.

MorganRamirez · Answer

Thank you so much for the solution.

Craige_Hales · Answer

What brand of database might help.

https://community.jmp.com/t5/Discussions/Byte-Array-Image-from-Database-to-JMP/m-p/16612#M15136 seems like it answers a similar question

***make sure your odbc drivers are up-to-date***

I'm not a database expert, but if the data is in the database and the query is truncating it, maybe something here will help.

https://www.sqlservercentral.com/forums/topic/255-char-limitation

https://stackoverflow.com/questions/19984934/why-a-long-text-field-is-returning-only-255-characters-in-a-ms-access-2013-query

https://board.phpbuilder.com/d/10329740-mssql-255-characters-limit-in-select/9

https://learn.microsoft.com/en-us/office/troubleshoot/access/linked-table-data-truncated