# Help with SQLite and liquibase.convertDataTypes

**URL:** <https://forum.liquibase.org/t/help-with-sqlite-and-liquibase-convertdatatypes/7518>\
**Category:** General Discussion\
**Created:** [November 14, 2022, 11:35am UTC](https://forum.liquibase.org/t/help-with-sqlite-and-liquibase-convertdatatypes/7518 "2022-11-14T11:35:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tt-mep](https://avatars.discourse-cdn.com/v4/letter/t/ac8455/32.png) [@tt-mep](https://forum.liquibase.org/u/tt-mep)\
**Post date:** [November 14, 2022, 11:35am UTC](https://forum.liquibase.org/t/help-with-sqlite-and-liquibase-convertdatatypes/7518/1 "2022-11-14T11:35:35Z")

</div>

Hello,  
I am facing a problem related to liquibase.convertDataTypes:

I set

`liquibase.convertDataTypes: false`

in the liquibase.properties file and the setting seems to be accepted correclty.

I have a liquibase xml script aimed to create a table containing also a “datetime” field in SQLite.

` <column name="eventDate" type="${datetime}"><constraints nullable="false"/></column>`

In the databasechangelog file there is a setting for property substitution:

`<property dbms="sqlite" name="datetime" value="DATETIME"/>`

With this setup I would expect that the SQL generated by liquibase is simply

`eventDate DATETIME NOT NULL,`

while is

`eventDate TEXT NOT NULL,`;

What am I doing wrong?

Liquibase version is: 4.16.1

Important note: I know that DATETIME “doesn’t exist” in SQLite, but it is possible to create tables using this type name, and after SQLite engine does the conversion using the type affinity ([Datatypes In SQLite](https://www.sqlite.org/datatype3.html), 3.3.1 Affinity Name Examples).

Another note: I see in the liquibase logs that only when db is sqlserver there is a line in the log telling that liquibase.convertDataTypes has found to be set to false, and this make me suspect that liquibase.convertDataTypes is ignored when db is not SQLServer. Possible?

Thanks

---

<div class="post-metadata">

**Author:** ![tabbyfoo](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/tabbyfoo/32/748_2.png) [@tabbyfoo](https://forum.liquibase.org/u/tabbyfoo)\
**Post date:** [December 14, 2022, 6:47am UTC](https://forum.liquibase.org/t/help-with-sqlite-and-liquibase-convertdatatypes/7518/2 "2022-12-14T06:47:08Z")

</div>

Did the [convert-data-types](https://docs.liquibase.com/parameters/convert-data-types.html) documentation provide any help with this? Would using [addNotNullConstraint](https://docs.liquibase.com/change-types/add-not-null-constraint.html) resolve the issue?