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