Question about storing binary data in a mysql database.

[notfred]

I need to store jpeg images in a mysql database. I'm using a certain scripting language, and have the jpeg file as a string. Do I need to escape anything in my string before storing it, or can I just do: inset into table values("$myjpegvariable");

I hope that makes sense.

 

[kt]

Use a blob field to store the image string.

 

[notfred]

I have the table set up to use longblobs, I want to know how to write the insert statement.

 

[kt]

Sorry, me brain dead today. Yes, you need to escape special characters before inserting into the database. What script are you using? With PHP you just need to use the addslashes() function to do it quickly.

 

[notfred]

Originally posted by: kt
Sorry, me brain dead today. Yes, you need to escape special characters before inserting into the database. What script are you using? With PHP you just need to use the addslashes() function to do it quickly.

I'm using perl with DBI. The documentation says to use quote(), but I tried that and it doesn't seem to give me valid data.

I'll read it again tomorrow.

 

[kt]

Originally posted by: notfred

Originally posted by: kt
Sorry, me brain dead today. Yes, you need to escape special characters before inserting into the database. What script are you using? With PHP you just need to use the addslashes() function to do it quickly.

I'm using perl with DBI. The documentation says to use quote(), but I tried that and it doesn't seem to give me valid data.

I'll read it again tomorrow.

Hmm.. strange. I've used the quote() function in DBI and haven't run into this problem before. Did you run the quote() function on your data string or your SQL statement string?