Forums > MaxMSP

sqlite version and column types?

December 6, 2011 | 2:28 am

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.


April 23, 2012 | 9:21 am

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


Viewing 2 posts - 1 through 2 (of 2 total)