[sqlite] what is the difference between TEXT and BLOB data type?

[jack wu]

other than encoded and not encoded.

i did not find the length limitations in the
documentation but seems like TEXT can only hold less
than 250 chars. is it true or is it SqliteExplorer
that only shows 250 chars. Thanks.