On 02 Sep 2016 at 15:05, Dave Blake <davebl...@kodi.tv> wrote: > 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?
Makes no difference whatever. See: <http://www.sqlite.org/datatype3.html> -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
