title: Whats the best SQLite data type for a long string
body: <p>In SQLite3 I am going to be storing a very long string that looks something like this:</p>
  
  <pre><code>string linkList = "www.blah.com,www.meh.com,www.hah.com"; 
  </code></pre>
  
  <p>will definitely exceed 255 chars, will probably be over 1000 chars</p>
  
  <p>Should the column <code>linkList</code> be a <code>varchar</code>, <a href="https://www.sqlite.org/datatype3.html#storage_classes_and_datatypes" rel="noreferrer"><code>TEXT</code></a> or something else to store a string that will probably be longer than 1000 chars</p>
  
  <pre><code>CREATE TABLE(uId INT PRIMARY KEY, linkList varchar);
  </code></pre>
  
  <p><strong>What would be the best variable type to use for the column <code>linkList</code>?</strong></p>