At 07:26 AM 14/01/2006 +0000, you wrote:

>Helen Borrie :
>
>Thanks for your reply.
>
>But, I can execute the sql in IBExpert , how do you explain this?

Well, the error you got was thrown by IBX. I think IBExpert uses FIBPlus
as its DA interface which probably (along with IBO and several other
interfaces) will truncate over-long strings to pre-empt overflows unless
specifically told to throw an exception instead.

It's also possible that IBExpert's SQL parser conditionally cleans up (as
you can do yourself, in your own code) by attempting to adjust any params
it detects as faulty in the context of the specified search. You could ask
about it on firebird-tools....

./hb