Ups! Can you double-check this? Personally I never had such problems,
but maybe I never was in such situation...

Roman

--- In Firebird-Java@y..., "Joachim Van der Auwera" <lists@t...>
wrote:

> I have noticed a bug in PreparedStatement
>
> I am running the following query
> SELECT UNID_UOID, UNID_CREATION, UNID_MODIFIED FROM "Batch"
> WHERE "Number"=?
>
> The UNI_UOID field is a 14 character field, the Number field is a 20
> character field. When I execute
> setString (ps,"12345678901234567890")
> I get a "Data truncation" error
>
> When debugging I see that the maximum field length according to the
> driver is 14 characters. I have also tested by having another first
> field, and it seems that the length is passed to the driver in hex,
> but not converted.
>
> --
> Joachim Van der Auwera
> CAB software, Nijlen