On 2018-08-28 09:50:01, "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?
I don't know all the ins and outs, but text columnns are convertible
between UTF-8 and UTF-16 upon request, whereas blobs are just byte
strings.
--
J. King
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users