sqlite version and column types?

CowboyTakeTwo's icon

I've read the brief sqlite tutorial online. When I try to run the getversion() function in the included .js I get an error that sqlite.getversion is not a function.

It seems like specifying a column type in a CREATE statement has no real effect on the column type. For example I can specify as INT(1) and still store a string there. I'm mostly concerned with the maximum size of character data that can be stored in this mystery column type being used by sqlite.

I know it's purposely undocumented/supported, but is there any info on this? Thanks.

Tj Shredder's icon

I think it is specific to SQLite, the columns accept any type according to this site: http://www.sqlite.org/datatype3.html