Just started using the much-improved v3.1.0 via PortableApps - Thanks!
However, I now find that columns with a declared type of TEXT with values which are UTF-8 strings longer than 1024 bytes now appear as (BLOB), both in the Browse Data tab and in the Execute SQL tab result pane. SQLite returns typeof() as 'text'.
Not sure what the previous PortableApps version was, but it displayed text values as text all the way up to my longest string of about 13K.
Is this a limit that you could consider raising/removing? (browsing/editing BLOB data is a tad less friendly than TEXT data!)