LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Query from database array limit of 251 bytes

I have a PostgreSQL bytea field where I've stored an array of 601 double values typecast into an unsigned byte array and stored in the field using the current PostgreSQL ODBC driver. 

 

Upon querying the same field through the ODBC data source using "DB Tools Select Data" from the NI_Database_API tools and then casting to an unsigned byte array using the "Database Variant to Data" VI I'm finding that my byte array is only reading valid values (by comparing back to the original unsigned byte array) up to the 251th byte.  Beyond that I'm just getting nonsense.

 

It's not an issue with the writing to the database.  I can query the bytea data by other means and verify that all the data I sent has gotten through.

 

Is there a limit to the size of an array cast by the "Database Variant to Data" tool?  Or is this a limitation of the query tool?

0 Kudos
Message 1 of 2
(2,455 Views)

Hi Mry,

 

Can you post a small version of what you have?  I want to see if I can get the same result.  As far as I know, there shouldn't be a limit to the size of the array. 

0 Kudos
Message 2 of 2
(2,436 Views)