On Fri, Feb 14, 2020 at 7:36 AM Simon Slavin <[email protected]> wrote:
> On 14 Feb 2020, at 2:59pm, Andy KU7T <[email protected]> wrote: > > > Do you suggest me keeping storing TEXT (and declaring the column as TEXT > instead of GUID) or storing and declaring BLOB (and remove HEX)? > > TEXT. Makes sorting and searching easier. > memcmp is harder than strcmp? and with blob I suppose you don't have 'if UTF8 or UTF16 do different things' so should compare slightly faster? > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
