In one SqLite table, I have a BLOB column for saving images (or binary data as a matter of fact). The table is Documents.
Strangely, in Subsonic's ActiveRecord's Documents开发者_开发技巧 class, the type of that column shows as STRING which doesn't make sense. It should be byte array. Right?
What am I missing here? How do I map SqLite BLOB column in Subsonic?
SQLite, believe it or not, does not have typed columns. Any data can be stored in any column (except INTEGER PK), regardless of how that column was declared. Each column has an "affinity", and that's what's reported to front ends that query the column's data type. In SQLite, the affinity for a BLOB column is returned as TEXT.
You can read more about it here.
精彩评论