Re: [sqlite] BLOB and TEXT comparisons
What's going on is that a Blob and a Text are logically different values and so
can never possibly equal each other.
Also they aren't represented by the same bytes either, because every value
includes its type and the comparison is comparing the bytes indicating the type
as well, which differ.
-- Darren Duncan
On 2019-07-12 7:19 a.m., Charles Leifer wrote:
I ran into a somewhat surprising result and wanted to just get a little
clarification.
I'll use the following statement as an example:
SELECT SUBSTR(?, 1, 3) == ?
And the parameters will be:
* "abcde"
* "abc"
If I bind both parameters using the same type, the comparison returns True:
* sqlite3_bind_text
* sqlite3_bind_blob
However, if I mix the types, e.g. sqlite3_bind_text("abcde") and
sqlite3_bind_blob("abc") then the comparison returns False.
Fom a byte-to-byte perspective, this comparison should always return True.
What's going on?
Thanks!
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] BLOB and TEXT comparisons
Charles Leifer wrote:
> SELECT SUBSTR(?, 1, 3) == ?
>
> However, if I mix the types, e.g. sqlite3_bind_text("abcde") and
> sqlite3_bind_blob("abc") then the comparison returns False.
>
> Fom a byte-to-byte perspective, this comparison should always return True.
>
> What's going on?
Apparently, not only a byte-to-byte comparison.
Withou affinity, only integer and real values can compare equal:
sqlite> select 1=1.0, 1='1', '1'=x'31';
1|0|0
See .
Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
