i'm trying to convert a mysql database to sqlite. i've been doing some research on the catches, and just want some advice on the datatypes.

i've always been anal enough to want to specify, as correctly as possible, things like datatypes. apparently, the creators of sqlite feel that specifying things like this is a mis-feature. they have created very generic datatypes. looking through the online documentation, they have made it even more generic in version 3.

so my question: should i even bother specifying if a field is boolean or not? or just call it an integer and get over it. same thing with varchar(xx) datatypes... just call it text and move on?

any help or kicks in the ass are appreciated.