Storing images into MySQL DB

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I'm currently trying to store images into my DB. But the collation used
on my DB is big5, since my client wants this default encoding on their
So to be able read the retreived data I have to use the command
mysql_query('SET NAMES big5');.

But when I do this, I'm not able to save the images to my DB. When I
attempt to, I recieve an SQL Error stating:

"You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
at line 1"

If I changed the command to mysql_query('SET NAMES utf-8'); there are
no errors and the images save properly.

I suppose the encoding of the binary data in big5 contains some type of
invalid character causing the SQL string to error.

Anyone know how I can get around this?

Re: Storing images into MySQL DB

steelghost wrote:
Quoted text here. Click to load it

Are you using mysql_real_escape_string on the image before storing it?

Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

Site Timeline