Sure, I'll try to get you something on Monday.

-----Original Message-----
From: Roman Rokytskyy [mailto:rrokytskyy@...]
Sent: Friday, October 03, 2003 7:15 PM
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Re: Like on BLOB limited to 28 characters in
prepared statement

> 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?

Roman


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.