characters can a MySQL DB not deal with

[crmpicco]

What characters can a MySQL DB not deal with in a insert query?

eg. the apostrophe.

Thanks.

[Tangerine Dream]

Hi, MySQL server can deal with any character including special characters like apostrophe (single quote), double quote, new line, etc. using apporpriate escape sequence like "\'", "\"", "\n", etc. Check 9.1.1. Strings (http://dev.mysql.com/doc/mysql/en/string-syntax.html)