sqlite version and column types?

Dec 6, 2011 at 2:28am

sqlite version and column types?

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.

Apr 23, 2012 at 9:21am

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


You must be logged in to reply to this topic.