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 <https://www.sqlite.org/datatype3.html#comparison_expressions>. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
