Hello, A program written in C# use SQLite datareader to read SQLite tables and columns. We have some problems now with SQLite columns which are declared as "int" (not INTEGER) It seems that the SQlite datareader recognice these columns as integer 32 bit. If we change the columns to "INTEGER" all works fine.
Sorry that I can't give you more details. I am no C# programmer. My questions are: 1. Had someone other here same problems with int columns and datareader? 2. We do a convertion from a MySQL db to SQLite with a tool. It converts all MySQL int(10) to SQLite int. Could it be a problem or does it matter if we convert all SQLite int columns to INTEGER? As I understand the docu, for SQLite it makes no difference. kind regards _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users