mysql & special characters

admin

Administrator
Staff member
I am using perl to enter data that contains single quotes into a mysql blob field. Then I am using php to display the contents of that field.

Right now I am using the CPAN URI:Escape to handle putting the data into the database but there isn't a friendly way in PHP to undo URI:Escape.

I was thinking of using uuencode/decode but maybe someone has a better way to handle this. Any thoughts?

It would be nice if mysql had a way to handle this that didn't have to envolve perl or php.

tks
mitch
 
Back
Top