Dear Keith, the point is the following you define a sqlite field as BOOLEAN at that poit the sqlite ADO.NET maps it to System.Boolean and it takes into account of an integer affinity You put a wrong "Y" in, if there is no check constraint, sqlite is typeless and accept it. It does not smell like an integer: GetBoolean - implemented in sqlite DataReader - correctly throw an exception But - and this is a Bug of sqlite ado net - the GetValue and GetFieldType are misleading as False and System.Boolean while they should throw the same exception and return System.String.
-- View this message in context: http://sqlite.1065341.n5.nabble.com/Boolean-and-DataReader-tp73521p73607.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
