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

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

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: Mike Toews <mwtoews(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 02:50:28
Message-ID: AANLkTimyzIxgnE3zyFWCcLOJYkYy_q4M3eWaR3CA6MTG@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
On Tue, Jun 15, 2010 at 7:43 PM, Mike Toews <mwtoews(at)gmail(dot)com> wrote:
> Oh, I did find a simple workaround by modifying my database:
>
> ALTER TABLE chem ALTER atomic_weight TYPE numeric(28,14);
>
> I guess my case for a bug is if the numeric data type has an
> unspecified scale, then it defaults to 6 for some unknown reason.

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.


-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

In response to

Responses

pgsql-odbc by date

Next:From: Mike ToewsDate: 2010-06-16 03:11:38
Subject: Re: Wrong scale for numeric data types in MS Access and ADODB
Previous:From: Mike ToewsDate: 2010-06-16 02:43:08
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