changing sqlite datetime column type

[Aaron Fischer]

When I use ormlite to create a sqlite table it's creating datetime fields as varchar(8000) is there a way to change this behavior?  I tried changing the dialect providers DateTimeColumnDefinition to "DATETIME" but that didn't work.

[Demis Bellot]

There is no DateTime data type in Sqlite, so we store dates as strings:

http://www.sqlite.org/datatype3.html 

On Fri, Jun 1, 2012 at 6:11 PM, Aaron Fischer <pretze...@gmail.com> wrote:

When I use ormlite to create a sqlite table it's creating datetime fields as varchar(8000) is there a way to change this behavior?  I tried changing the dialect providers DateTimeColumnDefinition to "DATETIME" but that didn't work.

--
- Demis

http://twitter.com/demisbellot

http://www.servicestack.net/mythz_blog