You're not exactly clear on where these restrictions come from, but, database wise, SQLite has no care or real control over what data it will retain, only the control that it will retain and attempt to protect your data. The application level is what determines what goes into the database.
- To look up info from the master table, [ select * from sqlite_master; ] - When retrieving or inserting info, you can use string manipulation which is documented here: http://www.sqlite.org/lang_corefunc.html There isn't anything that will state that a field is going to be only between a certain set of numbers, or of a particular case, etc. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users