encoding text for use in mysql table

2004-06-11T22:45:27-04:00

If you are using mysqltcl, use the 'mysqlescape' command...
You should consult the docs for the mysqltcl extension before asking such questions though..

Statistics: Posted by strikelight — Fri Jun 11, 2004 10:45 pm

encoding text for use in mysql table

2004-06-11T20:40:02-04:00

i've run into a problem when trying to insert data to a mysql table.

for example: when i try to insert a variable who's value is "because you're cool', it'll return an error saying my sql syntax is wrong because of the [b]'[/b] in "you're"

what i've been looking for is a script, or snippet, that will place \'s infront of all characters that will cause problems with mysql.

also, i need one that'll do the opposite, when i read data from a mysql table, that has been processed by the above script, i need a second script to remove any "\" that was inserted from the first script..

hopefully you all followed this :)

thanks,
Chad.

Statistics: Posted by Guest — Fri Jun 11, 2004 8:40 pm

egghelp/eggheads community

encoding text for use in mysql table

encoding text for use in mysql table