[sqlite] why does SQLite support VARCHAR(X) when the doc says it ignores it?

[Simon Slavin]

On 16 Jul 2015, at 10:46pm, Hayden Livingston <halivingston at gmail.com> wrote:

> It seems that
> 
> CREATE TABLE A( something varchar(255) )
> 
> it just
> 
> CREATE TABLE A( something text )
> 
> Why have it at all?

Lots of people take SQL code originally intended for other SQL engines, start 
up SQLite and want it to work first time.  So it does.  It won't perfectly copy 
the behaviour of engines which respect the '255' but it's good enough to assure 
the programmer that SQLite is worth using.

Simon.