Dr. Hipp,
D. Richard Hipp wrote:
A user has reported a bug saying that SQLite does not allow the '$' in the middle of indentifiers (without quoting). The bug reports says that statements like this:
CREATE TABLE ex$1( col$abc INTEGER );
are legal and work fine in other database engines. This seems very odd to me. Can anybody else confirm the use of '$' in the middle of identifier names in other database engines?
Yes. The statement works fine on MySQL 4.0.23 and on PostgreSQL 7.4.6, and I can insert values and get them back again.
I guess the next question is: Can someone verify that this is part of the SQL standard?
HTH
Ulrik P. -- Ulrik Petersen, Denmark
