title: String storage size in sqlite
body: <p>After using lots of <code>SQL Server</code> and <code>SQL Server Compact</code>, I have recently started to use <code>Sqlite</code>. I'm currently creating tables in Sqlite and have noticed that there doesn't seem to be any need to input the string length limit when defining string columns. In <code>SQL Server</code> a 255-character string datatype is defined like: <code>varchar(255)</code>. In <code>SQL Server Compact</code> it is defined like: <code>nvarchar(255)</code>.</p>
  
  <p>However, in <code>Sqlite</code>, it appears that the column datatype can be defined simply as <code>text</code>, without inputting any size limit. Is there a way to define a size limit in sqlite? Or is this not even necessary?</p>