On 8/9/05, Nuno Lucas <[EMAIL PROTECTED]> 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?
I don't think so.
> 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...
I'm not sure that it's a standard. I know Microsoft SQL Server and
Access DB use it, but from what I recall of the SQL92 standard, only
double quotes ("0_xy") are permitted for case-sensitive or otherwise
abnormal table and column names. Tables specified without this are
to be treated as uppercase only.
-austin
--
Austin Ziegler * [EMAIL PROTECTED]
* Alternate: [EMAIL PROTECTED]
