> Le 2 sept. 2016 à 16:05, Dave Blake <davebl...@kodi.tv> a écrit :
> 
> Can I confirm that defining feilds as VARCHAR(20) rather than TEXT, if I
> know I only want 20 chars or less,  will result in a smaller database?

That won't change anything. The (20) in VARCHAR(20) is purely 'documentation' 
for you, and insignificant to SQLite.  Which is very different to what you 
might find in other SQL engines.  The storage will be as small as possible, 
dynamic and identical in both cases.  Neither VARCHAR(20) nor TEXT will store 
anything more than required to store the length of the string and the string 
itself, as short or as long it is.  The length encoding itself is varying in 
size and won't cost you needless bytes for small lengths.

See https://sqlite.org/fileformat2.html and more specifically: 
https://sqlite.org/fileformat2.html#section_2_1

This https://sqlite.org/datatype3.html will tell you all there is to know about 
the datatypes in SQLite.

-- 
Meilleures salutations, Met vriendelijke groeten, Best Regards,
Olivier Mascia, integral.be/om



_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to