Subject Re: Like on BLOB limited to 28 characters in prepared statement
Author Roman Rokytskyy
> Check this out....
> If I do a LIKE search on a blob I have no problems. However, if the
> search criteria is greater than 28 characters I get a Data
> Truncation exception. However, the "same exact" search, succeeds in
> IBExpert. This is the exception trace:
> ...
> Just try doing a " LIKE " on a blob where the right hand side of the
> like is greater than 28 characters. Containing works fine.
> Thoughts?

Something seems to be wrong with the driver. DataTruncation exception
is generated by the driver when it detects that somebody passes longer
string than allowed (max. length is reported by the server).

Can you prepare standalone test case to reproduce the problem?