Re: Problem retrieving a numeric(38,0) value as SQL_NUMERIC_STRUCT if value needs to use all 16 SQLCHAR elements of the val array - Mailing list pgsql-odbc

Hi Walter,

Could you test a patch if I send it to you?

regards,
Hiroshi Inoue

(2014/06/03 4:03), Walter Couto wrote:
> 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


--
I am using the free version of SPAMfighter.
SPAMfighter has removed 10487 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Do you have a slow PC? Try a Free scan
http://www.spamfighter.com/SLOW-PCfighter?cid=sigen