-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 12/08/2014 10:30 AM, jose isaias cabrera wrote: >>> Hmmm... what I am looking for it is not there. If the "string >>> length" defined there is what defines the length of the name of >>> a table, I am in business. :-) However, there is nothing about >>> problematic characters. ie. <>!@#$%^&*()_+=-{}\|[]'";:?/.,, >>> etc., etc. in the table name.
SQLite supports all those, as well as zero length table names, column types and names. sqlite> create table " <>!@#$%^&*()_+=-{}\|[]'"";:?/.,, etc., etc. in the table name"("" ""); sqlite> .header on sqlite> pragma table_info(" <>!@#$%^&*()_+=-{}\|[]'"";:?/.,, etc., etc. in the table name"); cid|name|type|notnull|dflt_value|pk 0|||0||0 Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlSF764ACgkQmOOfHg372QRorQCcDbpSsjwclDLcKAiRQlFOC73M Sc8AnirtIkzx1v/5LWrAc1VYAGJ53MnS =bj14 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users