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. _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
