Problem retrieving a numeric(38,0) value as SQL_NUMERIC_STRUCT if value needs to use all 16 SQLCHAR elements of the val array

Make sure you have the following table and data created in the database:

CREATE TABLE NUMBER_TEST
(
test integer NOT NULL,
numeric_double_col numeric(38,0)
CONSTRAINT number_test_pkey PRIMARY KEY (test)
)
;
INSERT INTO NUMBER_TEST VALUES ( 6, 12345678901234567890123456789012345678 );
;

Execute the statement: select numeric_double_col from trunit.number_test where test = 6

Using the ODBC driver, bind using SQL_NUMERIC_STRUCT.

Expected values in the structure:

precision = 38
scale = 0
sign = 1
val = 0949B0F6F0023313C4499050DE38F34E

Actual values in the structure:

precision = 38
scale = -1
sign = 1
val = 0049B0F6F0023313C4499050DE38F34E

Other smaller values for the same column work fine. Any ideas?

Regards,
Walter

CONFIDENTIALITY NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.