title: SQLite dataypes lengths?
body: <p>I'm completely new to SQLite (actually 5 minutes ago), but I do know somewhat the Oracle and MySql backends.</p>
  
  <p><strong>The question</strong>: I'm trying to know the lengths of each of the datatypes supported by SQLite, such as the differences between a bigint and a smallint. I've searched across the SQLite documentation (only talks about affinity, <strong>only</strong> matters it?), SO threads, google... and found nothing.</p>
  
  <p><strong>My guess</strong>: I've just slightly revised the SQL92 specifications, which talk about datatypes and its relations but not about its lengths, which is quite obvious I assume. Yet I've come accross the Oracle and MySql datatypes specs, and the specified lengths are mostly identical for integers at least. Should I assume SQLite is using the same lengths?</p>
  
  <p><strong>Aside question</strong>: Have I missed something about the SQLite docs? Or have I missed something about SQL in general? Asking this because I can't really understand why the SQLite docs don't specify something as basic as the datatypes lengths. It just doesn't make sense to me! Although I'm sure there is a simple command to discover the lengths.. but why not writing them to the docs?</p>
  
  <p>Thank you!</p>