Jump to content

Database Connectivity Toolkit MYSQL BLOB Type


Recommended Posts

Hello to everybody,

I'm a newbie of Labview+MYSQL, and I need some help to this question. In an Datalog contest, I have a DB MYSQL and Labview 8.6.1 with Labview Database Connectivity Toolkit. Now, I'd store into a MYSQL BLOB columns a zip file (in binary form). How can i do this?

Any ideas

Thanks for the reply

Michele

Link to post
  • 2 weeks later...

QUOTE (Michele @ May 29 2009, 10:36 AM)

Hello to everybody,

I'm a newbie of Labview+MYSQL, and I need some help to this question. In an Datalog contest, I have a DB MYSQL and Labview 8.6.1 with Labview Database Connectivity Toolkit. Now, I'd store into a MYSQL BLOB columns a zip file (in binary form). How can i do this?

Any ideas

Thanks for the reply

Michele

Not sure about MySQL but for SQL Server I have been able to insert binary data into a BLOB field by using the binary data syntax. Basically it is a conversion from the binary data into its HEX codes such that the binary data 0x12 0x34 0x56 is formatted into the string '0x123456' and added to the SQL INSERT statement. I'm pretty sure MySQL supports a similar syntax.

Rolf Kalbermatter

Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.