On Sat, 1999-09-18 16:08:37 -0400, Mike Nolan wrote:
> ENUM Items should be in double quotes.
This is false.
For MySQL it doesn't matter, whether you enclose strings with double
(") or single (') quotes!
(For the exact details of quoting, please see chapter "7.1.1 Strings"
of the MySQL Reference Manual.)
I'm quite sure that any difference in behaviour--which you obviously
experienced--are because of the interface you use to issue the SQL
commands. There seems to be a quoting-related bug!
Did you make your experiments with the 'mysql' shell program? If not,
please do! And I'd be interested, what specific interface you're
using? (Web interfaces like phpMyAdmin, stand-alone programs like
xmysql, xmysaladmin, etc., some Windows software using the ODBC
driver, Java software using some JDBC driver, or self-written programs
using PHP, Perl-DBI, ...?)
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7