From: | "Inoue, Hiroshi" <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Walter Couto <Walter(dot)Couto(at)EMBARCADERO(dot)COM>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | 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 |
Date: | 2014-06-03 03:45:48 |
Message-ID: | 538D44EC.10201@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2014-06-03 05:41:22 | Re: Mentioning CPU for Windows build in docs |
Previous Message | Inoue, Hiroshi | 2014-06-03 03:43:22 | Re: Mentioning CPU for Windows build in docs |