"Reshat Sabiq" <sabiq@purdue.edu> writes:
> I believe Oracle requires singles for values too. That must be a
> standard.
It is. SQL92 contains
<double quote> ::= "
<quote> ::= '
<delimited identifier> ::=
<double quote> <delimited identifier body> <double quote>
<character string literal> ::=
[ <introducer><character set specification> ]
<quote> [ <character representation>... ] <quote>
[ { <separator>... <quote> [ <character representation>... ] <quote> }... ]
I can't believe that MySQL gets such a basic element of SQL syntax wrong
--- perhaps the OP is mistaken? If MySQL really does treat doublequote
as introducing a literal, how do they handle weird identifiers, like
names with embedded spaces?
regards, tom lane
