Hello,

Just to let you know that I found what we may call a bug, but not sure it is 
really one :

When storing DateTime Winrt variable in a DateTime SQLite field, it seems that 
the date is actually stored as a string with the DateTime.ToString() method.
To read it, it seems the engine uses DateTime.Parse() method.

The problem is with user langage switch :

If the user choose the indonesian langage as the system langage and stores a 
date time with the local format, the time will be stored as a string as 12.00 
for example, not 12:00.
If the user then read this data, still with indonesian language as the system 
language, no problem : the DateTime.Parse() method will works.
But if the user change the system language to english for example, then the 
DateTime.Parse() method will failed and and makes the app crash as for it, the 
time format is HH:MM, not HH.MM.

In my case, I just abandoned the DateTime format and now stores date with 
SQLite long fields using DateTime.ToBinary() and DateTime.FromBinary() methods?

Hope this should helps?

Best Regards,

Lionel Tranchand  - Mobile applications developer
FH SARL - 87, rue de S?ze - 69006 Lyon - France
www.fhsarl.com<http://www.fhsarl.com>

Reply via email to