Browse by Tags

Char is inserted into table as an Integer

SQLite inserts a Character as an Integer interpreted as the decimal ASCII value. This happens if you do not specify the DBtype of a parameter used in a SQLiteCommand. You can verify the problem with the code below. All the SQLiteCommands insert a Character/String as asumed. But the last one inserts a...

Posted to Bugs (Forum) by kws on 08-25-2009
Data type not inherited when creating tables by CREATE TABLE x AS SELECT * FROM y WHERE ...

I've found this BUG with1.0.65, later I checked with 1.0.63, but it performs the same. When creating tables using CREATE TABLE x AS SELECT * FROM y WHERE ... the created table does not inherit the data types of the original table! for example: The original 'BinaryAttachment' is: CREATE TABLE...

Posted to Bugs (Forum) by BilikTamas on 07-30-2009

Page 1 of 1 (2 items)

System.Data.SQLite