MySql: blobs

[aarushi2001]

Hi, I have a user form, which requires user to enter data. This field has been defined as 'blob'. The problem is if my textarea consists of ',' or ''' or '"', it gives an error.

How can I avoid this error?

 

[TonyGroves]

The problem would lie in the program code used to process the form data and compose the SQL query to update the database. You would need to check that code to ensure that the characters entered are properly escaped for use in an SQL string.

 

[aarushi2001]

Thanks Tony,

I was thinking when I update my table, a problem cud be there.

Sorry, but for first time I am encountering this problem.. do I need to catch this error.. or basically ask the code to ignore the escape characters? How can I do it?

 

[TonyGroves]

You have a few options -
- reject the form data back to the user
- strip out the offending characters from the text
- escape them as described in the manual, at

http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html

.

The first option might be difficult for the user to understand, the second could result in strange-looking data being saved, so the third is probably the best. The details of how to do it depend on your programming interface.