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

I am one of those people. I use SQLite and MS SQL Server and it is very convenient to have this cross compatibility. -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > Lots of people take SQL code originally intended

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

On 16 Jul 2015, at 10:46pm, Hayden Livingston 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

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

"Unlike most SQL databases, SQLite does not restrict the type of data that may be inserted into a column based on the columns declared type. Instead, SQLite uses dynamic typing . The declared type of a column is used to determine the affinity

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

Thanks! On Thu, Jul 16, 2015 at 2:50 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 07/16/2015 02:46 PM, Hayden Livingston wrote: >> It seems that >> >> CREATE TABLE A( something varchar(255) ) >> >> it just >> >> CREATE TABLE A( something text ) >> >> Why have

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

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/16/2015 02:46 PM, Hayden Livingston wrote: > It seems that > > CREATE TABLE A( something varchar(255) ) > > it just > > CREATE TABLE A( something text ) > > Why have it at all? Because other code and other humans look at the database too.

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

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