Integer and Int is equivalent in SQLite indeed, except in primary keys - where if you declare a primary key as INTEGER PRIMARY KEY
it becomes an alias for the rowid, and INT PRIMARY KEY is a normal Integer primary key but distinct from the rowid. In all other
cases they mean the same.
On 2014/05/15 08:22, Werner Kleiner wrote:
What I mean is: The original MySQL DB has columns with int(10). And the
converting tool converts all these columns in SQLite to Int
I can change the conversion so that all columns would be INTEGER in SQLite.
As I understand for SQLite it is equal if the column is declared as Int or
INTEGER?
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/SQLite-Datareader-problems-with-Int-tp75670p75674.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
