On 20 Feb 2018, at 4:21pm, Stephen Chrzanowski <pontia...@gmail.com> wrote:
> What I'm not entirely sure of is whether SQLite Expert is understanding and
> handling the BLOB_TEXT field and just not doing the actual query to get the
> text, or, if it understand if there is some kind of special handling that
> SQLite Expert is not doing and just shows (blob).
sqlite.exe always tells the unvarnished truth. Especially if you do things like
SELECT T1,typeof(T1),T2,typeof(T2) FROM Test
So if you're trying to work out what some other product is really doing, use
that third-party product to make the database, then use sqlite3.exe to open and
explore it. Probably starting with this command
.schema
Of course, you cannot predict the shortcomings of the third-party tool. For
instance, a product called (I just made this name up) _SQLite Manipulator_ may
use a string library which limits strings to 2048 characters. So it may,
undocumented, truncate all strings heading to the database.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
