Ara.T.Howard wrote: > > thus, you can insert blobs into a column declared INTEGER? i thought integer > columns were handled in a way that would prevent this? >
Perhaps you are thinking about INTEGER PRIMARY KEY columns. An INTEGER PRIMARY KEY column can only hold an integer, not a BLOB. But other INTEGER columns can hold anything you care to put in them. Note, however, that if you try to put a string that looks like an integer into an INTEGER column, it will convert the string into an integer automatically. See http://www.sqlite.org/datatype3.html for details.
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
