title: Difference Between "Text" and "String" datatype in SQLite
body: <p>I have a SQLite database with my Android application.  I have noticed I accidentally defined a table using a "String" datatype instead of "Text" datatype.  Here is the code with string:</p>
  
  <pre><code>private final String LISTDATES_CREATE = "create table if not exists ListDates (_id integer primary key autoincrement, ListName string not null, UpdateDate string not null);";
  </code></pre>
  
  <p>This works. It has never thrown an error and I can store and retrieve data.  However I can't find any reference to a "String" datatype in SQLite in the documentation or on the internet.  Typically, all string type data is defined with "text" like so:</p>
  
  <pre><code>private final String LISTDATES_CREATE = "create table if not exists ListDates (_id integer primary key autoincrement, ListName text not null, UpdateDate text not null);";
  </code></pre>
  
  <p>So my question is, what is the difference between a field defined with a "string" datatype versus a "text" datatype?  Is there a difference?  If so, what are the consequences, if any, of using one or the other?</p>