characters that must be escaped

[Jay]

Is there a definitive list of characters that must be escaped in order to
insert them into a text field in mysql?

TIA,
Jay

[steve]

"Jay" wrote:

Is there a definitive list of characters that must be escaped in order to
insert them into a text field in mysql?

TIA,
Jay

http://dev.mysql.com/doc/mysql/en/String_syntax.html

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-charac...ict132699.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=444521

[steve]

"steve" wrote:

[quote:7b55bfeb28="Jay"]Is there a definitive list of characters that must be escaped in order to
insert them into a text field in mysql?

TIA,
Jay

http://dev.mysql.com/doc/mysql/en/String_syntax.html[/quote:7b55bfeb28]

If you use php to insert into mysql, you can use mysql_escape_string
function, so you don’t have to worry about it:
http://ca2.php.net/mysql_escape_string

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-charac...ict132699.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=444551

[Raqueeb Hassan]

\0 An ASCII 0 (NUL) character.
\' A single quote (`'') character.
\" A double quote (`"') character.
\b A backspace character.
\n A newline character.
\r A carriage return character.
\t A tab character.
\z ASCII(26) (Control-Z). This character can be encoded to allow you
to work around the problem that ASCII(26) stands for END-OF-FILE on
Windows. (ASCII(26) will cause problems if you try to use mysql
database < filename.)
\\ A backslash (`\') character.
\% A `%' character. This is used to search for literal instances of
`%' in contexts where `%' would otherwise be interpreted as a wildcard
character. See section 6.3.2.1 String Comparison Functions.
\_ A `_' character. This is used to search for literal instances of
`_' in contexts where `_' would otherwise be interpreted as a wildcard
character. See section 6.3.2.1 String Comparison Functions.

See "http://mysqld.active-venture.com/String_syntax.html" for more
details.
--
raqueeb hassan
congo (drc)

[Jay]

"Raqueeb Hassan" <wi*******@gmail.com> wrote in message
news:81**************************@posting.google.c om...

\0 An ASCII 0 (NUL) character.
\' A single quote (`'') character.
\" A double quote (`"') character.
\b A backspace character.
\n A newline character.
\r A carriage return character.
\t A tab character.
\z ASCII(26) (Control-Z). This character can be encoded to allow you
to work around the problem that ASCII(26) stands for END-OF-FILE on
Windows. (ASCII(26) will cause problems if you try to use mysql
database < filename.)
\\ A backslash (`\') character.
\% A `%' character. This is used to search for literal instances of
`%' in contexts where `%' would otherwise be interpreted as a wildcard
character. See section 6.3.2.1 String Comparison Functions.
\_ A `_' character. This is used to search for literal instances of
`_' in contexts where `_' would otherwise be interpreted as a wildcard
character. See section 6.3.2.1 String Comparison Functions.

See "http://mysqld.active-venture.com/String_syntax.html" for more
details.

Thanks guys,
Jay

[steve]

"Jay" wrote:

Is there a definitive list of characters that must be escaped in order to
insert them into a text field in mysql?

TIA,
Jay

http://dev.mysql.com/doc/mysql/en/String_syntax.html

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-charac...ict132699.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=444521

[steve]

"steve" wrote:

[quote:7b55bfeb28="Jay"]Is there a definitive list of characters that must be escaped in order to
insert them into a text field in mysql?

TIA,
Jay

http://dev.mysql.com/doc/mysql/en/String_syntax.html[/quote:7b55bfeb28]

If you use php to insert into mysql, you can use mysql_escape_string
function, so you don’t have to worry about it:
http://ca2.php.net/mysql_escape_string

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-charac...ict132699.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=444551

[Raqueeb Hassan]

\0 An ASCII 0 (NUL) character.
\' A single quote (`'') character.
\" A double quote (`"') character.
\b A backspace character.
\n A newline character.
\r A carriage return character.
\t A tab character.
\z ASCII(26) (Control-Z). This character can be encoded to allow you
to work around the problem that ASCII(26) stands for END-OF-FILE on
Windows. (ASCII(26) will cause problems if you try to use mysql
database < filename.)
\\ A backslash (`\') character.
\% A `%' character. This is used to search for literal instances of
`%' in contexts where `%' would otherwise be interpreted as a wildcard
character. See section 6.3.2.1 String Comparison Functions.
\_ A `_' character. This is used to search for literal instances of
`_' in contexts where `_' would otherwise be interpreted as a wildcard
character. See section 6.3.2.1 String Comparison Functions.

See "http://mysqld.active-venture.com/String_syntax.html" for more
details.
--
raqueeb hassan
congo (drc)

[Jay]

"Raqueeb Hassan" <wi*******@gmail.com> wrote in message
news:81**************************@posting.google.c om...

\0 An ASCII 0 (NUL) character.
\' A single quote (`'') character.
\" A double quote (`"') character.
\b A backspace character.
\n A newline character.
\r A carriage return character.
\t A tab character.
\z ASCII(26) (Control-Z). This character can be encoded to allow you
to work around the problem that ASCII(26) stands for END-OF-FILE on
Windows. (ASCII(26) will cause problems if you try to use mysql
database < filename.)
\\ A backslash (`\') character.
\% A `%' character. This is used to search for literal instances of
`%' in contexts where `%' would otherwise be interpreted as a wildcard
character. See section 6.3.2.1 String Comparison Functions.
\_ A `_' character. This is used to search for literal instances of
`_' in contexts where `_' would otherwise be interpreted as a wildcard
character. See section 6.3.2.1 String Comparison Functions.

See "http://mysqld.active-venture.com/String_syntax.html" for more
details.

Thanks guys,
Jay