# DB Reader ignoring types for SQLite databases

**URL:** <https://forum.knime.com/t/db-reader-ignoring-types-for-sqlite-databases/46661>\
**Category:** KNIME Analytics Platform\
**Created:** [September 1, 2022, 12:26pm UTC](https://forum.knime.com/t/db-reader-ignoring-types-for-sqlite-databases/46661 "2022-09-01T12:26:58Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [September 1, 2022, 1:13pm UTC](https://forum.knime.com/t/db-reader-ignoring-types-for-sqlite-databases/46661/4 "2022-09-01T13:13:41Z")

</div>

@Vernalis it seems a [newer driver](https://forum.knime.com/t/sqlite-and-window-functions/31608/4) would fix that problem. I tested 3.36 and 3.39 and they both work fine.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/d/0ddad8aba20adbeb60064a3c0142b49375e2915d.png)

I had the 3.36 within my KNIME installation (or so I think). I installed the [latest one](https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc) in addition. @thor maybe KNIME can update the default driver.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/4/4/441d966ff812c70317ef4d67ba0b46a31b7d8d9a.png)

You can check the [SQLite version from KNIME](https://forum.knime.com/t/sqlite-and-window-functions/31608/2).

---

_[View the full topic](https://forum.knime.com/t/db-reader-ignoring-types-for-sqlite-databases/46661)._