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

Reply via email to