On 6/28/2016 2:35 PM, R Smith wrote:
On 2016/06/28 11:21 PM, R Smith wrote:
CREATE TABLE t(A TEXT COLLATE NOCASE, BTEXT COLLATE NOCASE);
Correction: I meant to paste that line below saying it is what you
need to fix the grouping, and added it to the script in stead. The
original meant to be without the NOCASE collations.
Thanks. I just changed my account settings so that instead of getting
only the digest, I get the individual emails. That seems to be required
if one wants to post and reply.
Regarding the failure of my StackOverflow-sourced query to find
duplicates, it seems you're right. Somehow, the two "device" values
shown in the table below are not the same, and I have no idea why. I get
both rows if I select where device like '%M14', but I get only one row
if select where device='M14', yet length(device) is 3 for both. Hmmmmm.
rowid device localtime type code
text udatetime jdatetime
18031 M14 2014-11-03 01:48:54 E 0 Failurefree
system 1415000934 2456964.825625
18062 M14 2014-11-03 01:48:54 E 0 Failurefree
system 1415000934 2456964.825625
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
Joe Pasquariello
Fenway Systems, LLC
2980 College Ave, Suite 7
Berkeley, CA 94705
510-665-4355
j...@fenway.com
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users