Lothar Scholz
<scholz-qqUfbLNYxjJCkLs28/[EMAIL PROTECTED]> wrote:
Subject: Re: Re: What is the precise definition of an identifier?
Further, SQLite also interprets strings enclosed in square brackets
as identifiers (for compatibility with MS Access, I believe):
Okay thanks. Do [ and " literals have any escaping for example "" in
the same way the single quote string literal is doing it.
Double quotes are escaped similarly to single quotes:
create table "a""b" (x);
select * from [a"b];
I don't know of any way to escape a closing bracket in bracket-delimited
identifier (which doesn't mean there's none). An opening bracket is not
a problem - [a[b] works as an identifier.
And just to ask it before i miss something: The double single quotes
'' is the only escaped character in SQLite string literals. Correct?
Yes, as far as I know.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
