[Mono-list] Single .dll targeted at multi platform but using sqlite, possible?

[KeithBoynton]

Gabriel Ibanez wrote
> 
> In mySQL boolean values doesn't exist as it. They are short int. You can
> deal with them like 0 as false and 1 as true.
> 
> /Gabriel
> 

Hi Gabriel, thanks for your response, I've actually resolved that problem.
Possibly a typo but we're discussing SQLite here not MySQL and the column
was actually being reported as an Int64 (long). But, in essence you're right
the Boolean storage class doesn't actually exist in SQlite and it is storing
them internally as 0s or 1s which I have to interpret and cast
appropriately. However that still seems strange given that there is a
GetType method (which technically should report Boolean) and GetBoolean()
which should give me the result as a Boolean. Anyhow, I'm over that now and
have worked around it.

Going back to the current issue, it looks like this LockEx issue could be
(related to) a "known" issue with the current build.
http://code.google.com/p/csharp-sqlite/issues/detail?id=128

Not sure if anyone has any experience of this or knows of what could be
wrong?



--
View this message in context: http://mono.1490590.n4.nabble.com/Single-dll-targeted-at-multi-platform-but-using-sqlite-possible-tp4656335p4656378.html
Sent from the Mono - General mailing list archive at Nabble.com.