You should use TEXT rather than string as the type of STUFF.
2007/2/9, Igor Tandetnik <[EMAIL PROTECTED]>:
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]
-----------------------------------------------------------------------------
--
powered by python
