> I'm trying to insert varchars into a field with a Insert and update
> query. Does anyone have a complete list of the charecters that need to be
> escaped/dealt with in order to get problem free queries on the INsert and
> Updates.
> ex. ' needs to be replaced with ''
I work with php. They have a funcion addslashes. This function
takes care of all those, so I don't have to. The function
definition says:
Returns a string with backslashes before characters that need to
be quoted in database queries etc. These characters are single
quote ('), double quote ("), backslash (\) and NUL (the null
byte).
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php