Subject Performing LIKE queries on a BLOB
Author Robert DiFalco
Are there size limitations on the size of a pattern if Firebird? For
example, if I have a BLOB with say 500 lines in it, I can search for
blob_field LIKE "line1%line70" and it works. But I can NOT search for
"line1%line200". It seems like it has to be a bug with the string
matching algorithm. I tried different segment sizes on the blob but this
had no impact. I haven't had a chance to check if there is the same
limitation of searching within large VARCHAR fields.