Vishal Mailinglist <list-p2Y/[EMAIL PROTECTED]> wrote:
Out of curiosity , in SQLite datatypes
http://sqlite.org/datatype3.html
its said that all the data in version 2.x all data was stored as
ASCII text , does this mean even if I create a table as
create table some(id INTEGER, location varchar(10)) ;
The data in column id and location both are in ASCII text
Yes.
if yes
what about in SQLite 3.
This is no longer the case in SQLite3.
Also am I correct in saying version 3 or 2 SQLite will not raise
error even if the data inserted is not as per data type mentioned in
create table syntax.
Correct. The declared type of a column is essentially treated as a
suggestion. SQLite will attempt to convert incoming data to this
suggested type, but if it can't, then it will store the data in its
original type. This is the crux of manifest typing.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
