开发者

Equivalent of SqLite Blob type in Subsonic?

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜