I am trying to select some rows using a search by blob field.

The query:

SELECT ID FROM TABLE WHERE BLOB_FIELD=?

does not raise any error, but it also always (incorrectly) returns 0
records as a result in Firebird (the same query works fine in Mysql).

Looking on the Net, I found that blobs to not support operator "=".
Additionally, I found the claims that blobs support LIKE operator.

Unfortunately, this query also behaves like the first one (no error,
but also no results):

SELECT ID FROM TABLE WHERE BLOB_FIELD LIKE ?

Is there any correct way to search by blobs ?

TIA