Database Connectivity Toolkit Data Types

[Marco_Ge]

It would be useful to improve the supported data types in the Toolkit (e.g. including the array[] column data type and other widely used data types and data structures in recent databases). 

In our application, a Select Query executed in LabView through the DB Toolkit in an a integer[] column, and the fetch all data .vi, returns only a fixed portion of the database stored array data (with data cut at 255), not the entire array. Only using of varchar or text column type solves the limtation.

This occurs without any warning to the user, so user does not notice the problem.

At least a user warning should be given.

[Petru_Tarabuta]

Hi Marco_Ge, I am not familiar with the behaviour you describe, but it sounds like a bug. It might be worth opening a Service Request and seeing if the support engineer can confirm this. Also, what LabVIEW version are you using? Have you tried running the offending code in the latest version (2026 Q1)? It might be worth trying 32-bit versus 64-bit too.

[Marco_Ge]

---

Hi Petru, thanks for your interest in this topic. Yes I've already had and email exchange with NI Service. They confirmed that this is an expected behaviour since the database column Array[] data type Is not supported by the Database Toolkit, so data comes out from the query with a cut at 255. This seems strange, even considering the attention to massive data storage in these years.

[Petru_Tarabuta]

Out of curiosity which database are you using? Could it be that the array[] column data type is specific to the database that you are using? I used Microsoft SQL Server in the past and don't remember coming across the array[] data type, but I could be wrong.

[Marco_Ge]

The database is Postgres. This is an extract of the DCToolkit supported data types; array type is missing.