Hi Simon, > > So you can declare a column as INTEGER and supply the string '1234' > and it will be converted to the number 1234 before it is stored. You > can check this out using > > SELECT x,typeof(x) FROM myTable > > This means that the conversion is done once on storage rather than > each time on retrieval, just as you would want for speed. If just > means that if you try to supply the string 'NaN' or 'infinity' for > the next row SQLite will still store it rather than generating an > error message. > > Simon. thx, can be useful.
regards, Nicolas