Re: [sqlite] More on Column types

Andre du Plessis wrote: What is the difference between: MYCOLUMN NUMERIC Vs MYCOLUMN INTEGER See http://www.sqlite.org/datatype3.html for a complete description of the difference. Or does it really mean nothing, I remember somewhere the default column type could be

[sqlite] More on Column types

What is the difference between: MYCOLUMN NUMERIC Vs MYCOLUMN INTEGER Or does it really mean nothing, I remember somewhere the default column type could be integer, after that it defaults to whatever you insert. But I was wondering... what would the preferred type be to A: