On 19 March 2013 15:08, [email protected] <[email protected]> wrote: > version 3.7.9 2011-11-01 00:52:41 > KUbuntu 12.04 LTS 32-bit > > ex1.sql > > CREATE TABLE table_ex1( > Groupid INTEGER PRIMARY KEY, > GroupName TEXT > ); > .separator '|' > .import ex1.csv table_ex1 > .quit > > ex1.csv > 1|NONE > 2|TWO > 3|THREE > 4|FOUR > 5|FIVE > > sqlite> .read ex1.sql > Error: datatype mismatch > sqlite> .quit > > ex2.sql > > CREATE TABLE table_ex1( > Groupid INT PRIMARY KEY, > GroupName TEXT > ); > .separator '|' > .import ex1.csv table_ex1 > .quit > > > sqlite> drop table table_ex1; > sqlite> .read ex2.sql > sqlite> .quit > > > Makes absolutely no sense. INT and INTEGER should be exactly the same. For > this limited set of data both should have worked.
INT and INTEGER are not exactly the same: http://www.sqlite.org/lang_createtable.html#rowid In version 3.7.15.1 your example does not produce the "datatype mismatch" error. > > Roland Hughes, President Regards, Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
