Subject | PreparedStatement problems |
---|---|
Author | Joachim Van der Auwera |
Post date | 2002-07-11T11:38:55Z |
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
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