Re: [sqlite] [EXTERNAL] Difference between hex notation and string notation

2019-12-16 Thread Keith Medcalf
onday, 16 December, 2019 00:42 >To: 'SQLite mailing list' >Subject: Re: [sqlite] [EXTERNAL] Difference between hex notation and >string notation > >The X'' notation returns a blob. LIKE works with strings. Comparing a >string to a blob of the same content always returns f

Re: [sqlite] [EXTERNAL] Difference between hex notation and string notation

2019-12-15 Thread Hick Gunter
. 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