On 1/7/2011 4:06 PM, Scott A Mintz wrote: > I have a fixed length value of six UINT16's. Is a blob the best way to > store it?
Depends on what you want to do with it. For example, do you need to filter on it in queries, e.g. "find all records where the second of those six integers is greater than 42" ? If you want to treat it as an opaque value, and just put it in and then later get it back out, then yes, a blob would be perfectly reasonable. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
