[antlr-interest] SQL string literals

[Pete Forman]

At 2002-05-31 13:58 -0700, Prasad K K wrote:
>You can use this Lexer rule
>
>SINGLE_QUOTED_STRING:
>(
>         ('\'') ( (~('\'')) )* ('\'')
>)+

That does not address my question.  Single quotes have the same
behaviour in SQL as doubles.  The question I posed stuck to the
simple case of double quotes.  Here are some more examples of the
full SQL string syntax.

   'foo' => foo
    'using ''quotes''' => using 'quotes'
    '''' => '
    '' => [empty string]
    'mixed "quotes"' => mixed "quotes"
    "mixed 'quotes'" => mixed 'quotes'

-- 
Pete Forman                -./\.-  Disclaimer: This post is originated
WesternGeco                  -./\.-   by myself and does not represent
pete.forman at westerngeco.com    -./\.-   opinion of Schlumberger, Baker
http://petef.port5.com           -./\.-   Hughes or their divisions.


 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/