[EMAIL PROTECTED] wrote:
Adding DATE and TIMEINTERVAL types to SQLite would require an
incompatible file format change.
well, yes, that was already clear. but: where is the type of the data
being stored? aren't there a few spare bits to use for 'future
additions', that is, new data types? sure, a file containing date data
would not be understood by executables where this has not been defined,
but maybe it is possible to do it so that they see a 'text'... or maybe
not...
And it would go against the
basic philosophy of SQLite.
in which way?
but as far as I am concerned, I'll be happy if I can get the original
type declaration for the column by querying the database. is there a
way to do so? I've looked into the doc (for example,
"information_schema") but I found nothing which was working for me...
thanks and regards,
MF