SQLite Forum

null character sorts greater than 0x7f and less than 0x80
Where is this policy of accepting an arbitrary sequence of bytes for the "text"
storage class stated?  Doesn't it contradict SQLite's own documentation, which
provides the following definition of the "text" storage class?
  Text. The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16LE)

Isn't the whole point of the "blob" storage class to have a place to hold
values that aren't valid for the "text" class?  Wouldn't the appropriate
interpretation of a value that is not valid in the encoding of the database
then be "blob"?  Why even have a "text" storage class if that's not what it is?
Alternatively, why have a "blob" storage class if "text" accepts arbitrary

So SQLite doesn't allow the null character in a text value?  If so, that means
SQLite is not capable of storing all possible Unicode strings.  I had supposed
this was one of the big advantages of SQLite over, i.e. PostgreSQL.