The X'' notation returns a blob. LIKE works with strings. Comparing a string to a blob of the same content always returns false.
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Sascha Ziemann Gesendet: Freitag, 13. Dezember 2019 10:16 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] Difference between hex notation and string notation I have a problem to find rows in a database when I write in hex notation: CREATE TABLE LOG (MSG VARCHAR(6291456) NOT NULL); INSERT INTO LOG VALUES (X'666163696c6974793d6461656d6f6e3b636f6d706f6e656e743d6e616d65643b746578743d7368757474696e6720646f776e'); INSERT INTO LOG VALUES ('facility=daemon;component=named;text=shutting down'); SELECT ROWID,MSG FROM LOG; -- returns both rows SELECT ROWID,MSG FROM LOG WHERE MSG LIKE '%down'; -- returns just the second SELECT ROWID,MSG FROM LOG WHERE CAST(MSG AS VARCHAR) LIKE '%down'; -- returns both rows This looks like a bug to me. Regards _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
