| Subject | Re: DataTruncation when querying with like and % |
|---|---|
| Author | Adam |
| Post date | 2006-09-08T00:06:41Z |
--- In firebird-support@yahoogroups.com, José Manuel Rus
<josemrus@...> wrote:
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.
Adam
<josemrus@...> wrote:
>Nope, might be related to Jaybird, but in iSQL this 'works':
> 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.
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.
Adam