SQLite Forum

Integer becomes blob
Login
Your CREATE TABLE statement uses column type <b>int</b> instead of the prescribed <b>INTEGER</b> keyword.

Python might not understand what you mean.

Try to change:
```sql 
CREATE TABLE IF NOT EXISTS rsbuddy (
                                        id integer PRIMARY KEY,
                                        item_name text,
                                        item_id int,
                                        ts int,
```
etcetera, into:

```sql
CREATE TABLE IF NOT EXISTS rsbuddy (
                                        id INTEGER PRIMARY KEY,
                                        item_name TEXT,
                                        item_id INTEGER,
                                        ts INTEGER,
```
etcetera.

I hope this helps

~~~
-- 
Regards,
Kees Nuyt
~~~