Posted by Jerry Stuckle on 07/16/07 11:22

Toby A Inkster wrote:
> Jerry Stuckle wrote:
>
>> Nope, actually both are non-standard extensions. Quotes have no
>> definition in standard SQL. Rather, table/column names can't be
>> reserved words like GROUP, COLUMN, etc.
>
> No -- Andy was right. ANSI SQL (and the later ISO editions) specifies that
> double-quotes may be used to quote identifiers. Single quotes are used for
> strings; backticks aren't used for anything in particular.
>
> This is one of MySQL's most annoying quirks: in its normal mode it accepts
> double-quotes for string values and insists on only backtick-quoted or
> unquoted literals. Putting MySQL into ANSI mode fixes it.
>

Looks like I need to get an updated version of the SQL standard then.
The one I have doesn't indicate double quotes are legal. Can you point
me to the section in the ANSI standard which shows that? It would save
me a lot of looking - these things are not the easiest to read :-).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]