Robert Simpson <[EMAIL PROTECTED]>
wrote:
Issued from the 3.3.12 comand-line:
CREATE TABLE blah (ID INTEGER PRIMARY KEY, STUFF string NOT NULL);
INSERT INTO blah (STUFF) VALUES('00302');
SELECT * FROM blah;
1|302
Same query, slightly different table definition:
CREATE TABLE blah (ID INTEGER PRIMARY KEY, STUFF text NOT NULL);
INSERT INTO blah (STUFF) VALUES('00302');
SELECT * FROM blah;
1|00302
Should there be a difference between declaring a column as type
'text' and type 'string' ?
Read about SQLite type model here:
http://www.sqlite.org/datatype3.html
In particular the notion of column type affinity.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
