On 22 Apr 2016, at 2:09pm, Igor Korot <ikorot01 at gmail.com> wrote:
> The field type is set to be "varchar(100)" for the name field. > Wouldn't it be more logical to have it as "varchar" and have another field > for data size? What you are seeing there is SQLite just repeating back the type that the CREATE TABLE command used. It is not the type of data SQLite is actually storing. There is no 'varchar' datatype in SQLite. And it never truncates strings. I think that the best thing for you may be to read this page <https://www.sqlite.org/datatype3.html> and get back to us if you have further questions. Simon.
