SQLite records have fields that are variable sized and encode type and length information for each field and no table constraint changes this. The table constraints only change how some values are interpreted.
On Thu, Aug 27, 2015 at 7:06 AM, Nicolas J?ger <jagernicolas at legtux.org> wrote: > Hi Darko, Igor and others. > > so the only reason to define datatype in sqlite is for the size on > the disk ? > > so why not just only using `BLOB` (excepted for `INTEGER PRIMARY > KEY`) ? > > being less persmissive wouldn't make querries run faster ? > for example, the comparisons would not have to try to attempt to > convert or even check and determine the type of the values. > > regards, > Nicolas J. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
