> What effect has dimension on field size? ... See <http://www.sqlite.org/datatypes.html> and <http://www.sqlite.org/datatype3.html>.
The dimension(s) has no effect on the actual storage. > And why is it valid when you mention "date" ... ? The type in a create statement serves only to determine the type affinity for the column. Specified type can be anything. If 'date' is specified for the type, the column will have type affinity 'numeric'. See the files mentioned above. Regards
