In SQLite3 I am going to be storing a very long string that looks something like this:
string linkList = "www.blah.com,www.meh.com,www.hah.com";
CREATE TABLE(uId INT PRIMARY KEY, linkList varchar);
You should use
TEXT. Although, that's the same thing as
If the declared type of the column contains any of the strings "CHAR", "CLOB", or "TEXT" then that column has TEXT affinity. Notice that the type VARCHAR contains the string "CHAR" and is thus assigned TEXT affinity
Note that numeric arguments in parentheses that following the type name (ex: "VARCHAR(255)") are ignored by SQLite - SQLite does not impose any length restrictions (other than the large global SQLITE_MAX_LENGTH limit) on the length of strings, BLOBs or numeric values.