|Problems? Is your data what you think it is?|
Re^2: SQLite and Storable: is "Text" okay?by BrowserUk (Pope)
|on Oct 06, 2010 at 15:51 UTC||Need Help??|
Each value stored in an SQLite database (or manipulated by the database engine) has one of the following storage classes:
That implies that SQLite performs some manipulation (encoding and/or decoding) upon fields designated as TEXT.
Storable stores integers in binary, which means that some value, or some subset of the bytes making up that value might look like some unicode entity that is illegal or has some special meaning (like Byte Order Mark: 0xFFFE or 0xFEFF), that would cause the round trip into and out of the DB to change the content some how.
I'd be very much inclined to using BLOB for Storable data.
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.