I understand that any ASCII character can be stored within any of the
non-numeric type fields. Does this mean just characters 1-255?
What happens if I try to import a non-ASCII character, let say, into
a VARCHAR field? Is it discarded or will I simply not be able to get
into a MySQL field in the first place?
In addition, do all of the following need to be escaped before being
insert into a database?
\0 An ASCII 0 (NUL) character
\n A newline character
\t A tab character
\r A carriage return character
\b A backspace character
\' A single quote (`'') character
\" A double quote (`"') character
\\ A backslash (`\') character
\% A `%' character (this is used to search for literal instances of
`%' in contexts where `%' would otherwise be interpreted as a
wild-card character)
\_ A `_' character (this is used to search for literal instances of
`_' in contexts where `_' would otherwise be interpreted as a
wild-card character)
In other words, am I correct that none of these characters can be
stored in a MySQL string field (such as CHAR, VARCHAR, or TEXT)?
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA ||| http://www.lassodev.com
---------------------------------------------------------------------
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
