I seem to remember that BLOBs cannot be indexed. I can’t find documentation on that though. Does anyone else recall the same thing and have a link, or maybe someone can correct me?
Ben On Tue, Aug 28, 2018 at 6:50 AM Tim Streater <t...@clothears.org.uk> wrote: > What is actually the difference between a column declared as TEXT and one > declared as BLOB in an SQLite database? What does SQLite do to textual data > that I ask it to put into a TEXT column? How does it know not to do that if > I want to send some binary data to a Text column? > > The reason I'm interested is that I have a table with a TEXT column. For > backwards compatibility reasons, I'd like not to change the column's type > or even add another column with BLOB type. Up to now I've assumed that the > data to go in the column was all ASCII or perhaps UTF-8. Now it seems that > it's legal for it to be a mixture of encodings. So I want to treat it as > binary and be able to just use the existing TEXT column. Anything I need to > look out for? > > > -- > Cheers -- Tim > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Ben _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users