LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

LabVIEW Database Connectivity Toolkit can write strings longer than 255 characters but cannot read them?

Solved!
Go to solution

Have an issue with arrays stored as strings in an SQLlite database. Have no issue writing the data in the first place but reading them back in appears to be an issue. 

 

At 255 Characters the select function seems to get upset and returns a question mark, but then weirdly continues on to concatenate part of the next column, cutting off the existing columns real values. it continues adding the values from the wrong column until it reaches the full expected size of the column data. 

 

Example (next column in red):

1561.660 1561.710 1561.760 1561.810 1561.860 1561.910 1561.960 1562.010 1562.060 1562.110 1562.160 1562.210 1562.260 1562.310 1562.360 1562.410 1562.460 1562.510 1562.560 1562.610 1562.660 1562.710 1562.760 1562.810 1562.860 1562.910 1562.960 1563.010 156? 1260.000 1260.000 1260.000 1260.000 1260.000 1260.000 1260.000 1260.000 1260.000 1260.000 1260.000 12

 

other weirdness, I cannot copy the error result directly from the text indicator that it outputs to, it cuts off at point of the error when you try to paste the output

 

any ideas?

 

MH

0 Kudos
Message 1 of 2
(927 Views)
Solution
Accepted by topic author mslhutchinson

Never mind, seems to be an issue on the SQLlite / ODBC side.

 

Changing the definition of my SQLlite database columns from STRING to TEXT solved the issue. 

0 Kudos
Message 2 of 2
(919 Views)