| Subject | Performing LIKE queries on a BLOB |
|---|---|
| Author | Robert DiFalco |
| Post date | 2003-10-03T21:21:48Z |
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.
TIA,
R.
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.
TIA,
R.