Skip site navigation (1) Skip section navigation (2)

Re: Wrong scale for numeric data types in MS Access and ADODB

From: Mike Toews <mwtoews(at)gmail(dot)com>
To: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Wrong scale for numeric data types in MS Access and ADODB
Date: 2010-06-16 03:11:38
Message-ID: AANLkTimiBcnBK8LdmVjLP8ELjofBx_Tu0MuVmo-W3rFo@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
On 15 June 2010 19:50, Richard Broersma <richard(dot)broersma(at)gmail(dot)com> wrote:
> I did a quick google search and came up with the following document:
>
> http://support.microsoft.com/kb/214854
>
> I think that it helps to explain part of the issue your seeing.

Thanks, the document helps in understand how JET interprets database
types. But it does not mention anything about defaulting to scale of 6
if scale is not specified for numeric types, so I'm still unsure who
is to blame for this behaviour.

-Mike

In response to

pgsql-odbc by date

Next:From: Jaime CasanovaDate: 2010-06-16 17:18:37
Subject: Re: memory leak in psqlodb 08.04.0200
Previous:From: Richard BroersmaDate: 2010-06-16 02:50:28
Subject: Re: Wrong scale for numeric data types in MS Access and ADODB

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group