I have a string of 39KB that I want to store into a SQL server 2000 table. The defined field in the table is "text" because a "nvarchar" type can only store up to 8KB. The problem now is that the NI ODBC toolkit converts a LabVIEW string into a varchar field (see supported data types). That's why SQLserver always generates an error telling me that the data is truncated (because it is treated as varchar data with a Max of 8KB data storage). Is there a way to change the supported data type? This way I could the ODBC toolkit interpret string data as text data and the problem would be solved.
