Is there a prefered way to specify a text column in SQLite? Is there a prefered way to specify a text column in SQLite? sqlite sqlite

Is there a prefered way to specify a text column in SQLite?


The advantage of using varchar(x) is that it is compatible with other database systems - if I remember correctly, TEXT isn't a standard SQL datatype.

Other than being more standards-compliant, there is indeed no difference whether you use TEXT or VARCHAR. More info at http://sqlite.org/datatype3.html