Posted by Jerry Stuckle on 07/16/07 16:00

Andy Hassall wrote:
> On Mon, 16 Jul 2007 07:22:37 -0400, Jerry Stuckle <jstucklex@attglobal.net>
> wrote:
>
>> 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 :-).
>
> The production for <delimited-identifier> appears to be the place to look,
> then you can track back from there up to the identifier and then select list
> definitions.
>
> <delimited identifier> ::=
> <double quote> <delimited identifier body> <double quote>
>
>

Thanks, I'll give it a look.

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

• Next in forum: Re: php session was not working on the firefox
• Prev in forum: php session was not working on the firefox
• Thread view: Re: How do I escape parentheses in a mysql query?

[Reply to this message]