Re: Searching by Guid index in table (.NET)? I can write and read, but not search by the Guid
J Decker <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CAA2GJqVdbmrfac3JXt9aCJpdJWcNm_byj0wOLRB7h=79KSiY6w@mail.gmail.com> |
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