At 8:46 PM +0100 8/9/05, Nuno Lucas wrote:
[09-08-2005 19:05, ender escreveu]
[...]
So my simple feature request would be: allow '`' as a quoting symbol -
as mySQL does. Or - what would be as helpful as the other idea - allow
unquoted column names with leading digits - as mySQL does.
Does MySQL allows [0_xy] to specify column names?
If I remember correctly, that is the standard SQL way to have columns
with spaces in the middle, and sqlite allows columns starting with a
digit in this way...
Regards,
~Nuno Lucas
The SQL standard has both delimited and bareword identifiers.
Bareword identifiers can only be letters, numbers, and underscore,
and start with a letter, to my knowledge; they are also
case-insensitive.
Delimited identifiers can have any characters in them, including
spaces, and they are delimited with double-quotes (") usually.
The standard may allow other delimiting characters, but I'm not sure.
I imagine that back-ticks (`) may be safe to support if they aren't
already used by SQL in some other way. You certainly don't want to
use single-quotes (') as those are always literal string delimiters.
You also don't want to use brackets ([]) as those are used by the
standard for array indices.
I suggest for simplicity that SQLite simply support single-quotes for
string delimiters and double-quotes for identifiers; clearly distinct
and simple.
-- Darren Duncan
