SQLite Forum

Integer becomes blob
manually executing this command gives me no problem and stores the data correct.

> insert or ignore into rsbuddy ("item_name","item_id","ts","overallPrice","overallQuantity","buyingPrice","buyingQuantity","sellingPrice","sellingQuantity")VALUES('Twisted trousers (t1)', 24409, 1587490, 350000, 1, 350000, 1, 0, 0);

i think i have identified the issue, apparently providing a numpy record was the problem, it must have a numpy array (record is an array with datatypes)