Insert Pictures from MySQL by LabSQL

[the mew of night]

I am trying to  insert pictures file into MySQL database by using LabSQL. From the LabSQL samples I got, I can fetach a table, insert and update date into the MySQL table , but I dunno the right way how to insert a picture file into the  database. Can anybody help ?

[Coq_Rouge]

take a look at this, and the blob sql type http://dev.mysql.com/doc/refman/5.0/en/string-types.html. Use the cast function in labview for casting the picture data  to a text string

[mikeporter]

Simply flattening the image data to a string won't work because the SQL parser will interpret some of the byte values as delimiters that will cause the inert to fail. See this thread for a discussion of this same issue.

Mike...

[Coq_Rouge]

I have used the BLOB type and Mysql for storing pictures. But not in Labview. Is it any problems with the BLOB type in Labview? I also think one of my co-worker used this free toolkit and Mysql with no problem http://performancemicrowave.com/sql_LV.html

[mikeporter]

There is no problem with working with BLOBs in LV. The main issue (and it's a big one) with the indicated library of drivers is that they utilize a custom DLL - which hasn't been necessary since LabVIEW V4! Whoever created these drivers is clearly not very familiar with LV.

The drivers referenced in the linked thread uses the ADO capability built into Windows.

Mike...