Hi there,
I am trying to insert uploaded files into a M$ SQL 2000 database. The uploaded files are validated as either PDF or HTML and then passed to the database. They need to be stored in an image column so that they can be indexed for fulltext searching.
Currently I get the following error when inserting the files into the db -
"Operand type clash: text is incompatible with image"
The files are read into a buffer and then they are prepared for the insert. I have tried both addslashes() and replacing a "'" (single quote) with "''" (two single quotes). I have seen suggestions that the data should be base64encode()'ed but can't get anything to work consistantly.
I will be very grateful for any help.
TIA
Nick
