search

cygnusxi / hfm-net

Automatically exported from code.google.com/p/hfm-net
2 stars 0 forks source link

Problem with mixed UTC and non-UTC date & time values being written to and read from SQLite. #287

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
The v0.9.1 update included a new version of the System.Data.SQLite data 
provider (v1.0.81.0).  This updated version of SQLite writes DateTime 
structures with DateTimeKind.Utc with a "Z" ack on the database value.  When 
reading from the database.  Only values with the "Z" ack are considered UTC.  
Other values without the "Z" ack are now considered local time.  However, these 
existing values are also UTC.

SQLite can be told to treat all DateTime values as UTC by adding 
"DateTimeKind=Utc" to the database connection string.

Making this change will also fix the issue with duplicate entries being written 
to the database.  However, I still need to develop a fix for this so the 
duplicates are removed upon the v0.9.2 update.

I'm not sure how this will effect those running on Mono and relying on any 
included SQLite database.  Maybe I should make a version check on SQLite to 
make sure the available library is of at least a specific version.

Original issue reported on code.google.com by harlam357 on 23 Nov 2012 at 4:14

GoogleCodeExporter commented 8 years ago

Original comment by harlam357 on 4 Sep 2014 at 2:50