Inserting raw (binary?) image data into mysql? (PHP)

Question

I've got a raw/(binary?) image like this:

ÿØÿà�JFIF��–�–�*!!!$'$ &(goes on forever);

when i try to insert this into mysql it doesn't work, the column type is set to longblob, any ideas?

Show us your php code and we may be able to provide more insight — Asaph
– Asaph, Commented Sep 12, 2009 at 6:24
i can't set the encoding for a longblob, but karim79's solution worked perfectly. — Mickey
– Mickey, Commented Sep 12, 2009 at 6:26

karim79 · Accepted Answer · 2009-09-12 06:22:45Z

3

I think you need to escape that using mysql_real_escape_string before inserting into the database.

answered Sep 12, 2009 at 6:22

karim79

343k67 gold badges420 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

S.L. Barth is on codidact.com · Accepted Answer · 2012-11-13 06:27:39Z

0

mysql_real_escape_string for php_mysql
mysqli_real_escape_string or prepare statement for php_mysqli

8,25371 gold badges55 silver badges68 bronze badges

answered Sep 12, 2009 at 7:05

sskaje