| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>, <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: Wrong numeric conversion |
| Date: | 2005-01-17 10:13:29 |
| Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4528442@ratbert.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Andreas Pflug
> Sent: 16 January 2005 15:26
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Wrong numeric conversion
>
> With CVS HEAD, numeric values are not read correctly.
> The SQL_NUMERIC_STRUCT is filled with
> .precision=3, .scale=5 for a number like 500.00123, which
> MSDASQL will
> interpret as .00123 (noticed when MSDASQL had to convert it to a
> string). Obviously the precision should be 8 or more.
> The attached patch corrects this.
Thanks Andreas, patch applied.
Regards, Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James M Doherty PGADMIN | 2005-01-17 14:13:30 | Re: ODBC release plans? |
| Previous Message | Andreas Pflug | 2005-01-16 15:26:18 | Wrong numeric conversion |