07-15-2009 06:09 PM
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?
07-16-2009 04:29 PM
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.