|Subject||Re: Like on BLOB limited to 28 characters in prepared statement|
> Check this out....Something seems to be wrong with the driver. DataTruncation exception
> 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.
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?