-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 24/02/12 07:22, Simon Slavin wrote:
> I can't find any documentation about what SQLite considers to be an
> acceptable table name.
Providing you use quotation, anything is acceptable as a table name
including zero length strings.
create table "create table select(create)"("" [select select]);
A table named "create table select(create)" with a zero length column name
of type "select select". Full unicode works too. About the only thing
you can't do is use a name that requires multiple kinds of quoting (double
quotes and []) simultaneously.
The issue that OP has is that the shell strips off one level of quoting
under some circumstances (dot commands), so there are situations where you
effectively have to quote names twice.
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iEYEARECAAYFAk9H7F8ACgkQmOOfHg372QSGNACgjYTKtmGwmhaRD+oZvvkabLaf
4C4Anj9ArJa8x+RPMi4aXUeUKeSEEpyo
=kjFY
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
