Subject Re: DataTruncation when querying with like and %
Author Adam
--- In, José Manuel Rus
<josemrus@...> wrote:
> Hi,
> The problem is that 'like' queries throw DataTruncation exceptions or
> produce empty results when the search text reachs the column length or
> the column length -1.
> I'm using Firebird 1.5.3 together with JayBird 2.0.1/2.1.0 (embedded)
> and Hibernate 3.1.3, but I'm posting here because it seems to me that
> this is more related to Firebird.

Nope, might be related to Jaybird, but in iSQL this 'works':

select *
from employee
where firstname like '1234567890123456789012345678901234567890%';

firstname is defined as varchar(30). Returns no records obviously.
Feel free to try it yourself using iSQL, FlameRobin or whatever.

Then try the Jaybird list.