On Fri, Feb 14, 2020 at 7:36 AM Simon Slavin <slav...@bigfraud.org> wrote:
> On 14 Feb 2020, at 2:59pm, Andy KU7T <k...@ku7t.org> 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 > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users