I am trying to write a binary file to an SQL database (with two columns: ID and data). Using the subvi "Read from Binary File", the output is a String which I then try to write to a database. I can do this if two conditions are met: The data type in the database is string based, such as nvarchar(MAX), varchar(MAX), text, etc. The amount of data is less than 8000 bytes. I am running into an issue where if I write more than 8k of data, I get the error: "String data, right truncation". My understanding is the data types I listed above are supposed to handle up to about 2GB, so this is confusing. I'm not sure if this will make a difference, but I want to use a data type of varbinary(MAX). However, when I use the "Read from Binary File", I get a String output. When I try to write this to the database using "DB Tools Insert Data VI", I get the error:"Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query." I'm guessing "CONVERT" is part of the SQL query language and is a standard error returned by either the database or ODBC driver? In other words, not something I have direct access to? Is there a way to convert the data into something (binary) that the database will not complain about? I'm just savvy enough in SQL to understand some of this functionality, but would consider myself a novice. I appreciate any help!

LabVIEW

Write binary data to DB

Thank you. This solution worked for me perfectly. I was trying to insert an jpeg image of 200kB into a varbinary(max) and had the same error. I have Labview 2018 and this problem is still there. Now it is fixed until I reinstall the toolkit.

Message 11 of 11

(46 Views)

LabVIEW

Write binary data to DB

Re: Write binary data to DB