Submitted by: johnvandew (johnvandew)

Is related to JDBC132
Is duplicated by CORE4663
Relate to CORE3559

Votes: 4

SFID: 1060280#⁠
Submitted By: johnvandew

Hi,
Using FB 1.5, both embedded and server,
D7 with Zeos

all on WinXP sp2

field 'name' is varchar(10)

OK:
Select * from ATable
where name = 'a_big_name'

OK:
Select * from ATable
where name = 'a_bigger_name'

OK:
Select * from ATable
where name = :AName
Params[0].AsString:='a_big_name'

Error:
Select * from ATable
where name = :AName
Params[0].AsString:='a_bigger_name'

OK:
Select * from ATable
where Cast(name as VARCHAR(100) = :AName
Params[0].AsString:='a_bigger_name'

I have to cast the field to a large field to prevent
error occurring...

Same result with LIKE and CONTAINING
Using ZEOS: Error -303

bug?

Kind Regards,
John