I will need to filter on it. The six word field is called a RxIOI. So I will need to select records where the RxIOI equals a specified value.
Is this valid if RxIOI is a blob?: select xyz from t where RxIOI = x'1234567890ab'; -Scott [email protected] wrote on 01/07/2011 04:32:13 PM: > 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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
