> 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