Message-ID: <XFMail.000127110301.alter.ego@iol.it>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
In-Reply-To: <388FC835.F64ACB6F@home.com>
Date: Thu, 27 Jan 2000 11:03:01 +0100 (CET)
Sender: alter@alteria.iol.it
From: Stefano Garavaglia <alter.ego@iol.it>
To: pgsql-interfaces@postgreSQL.org
Subject: Problem with numeric and Ms Access

I'm having some problem using postgresql-6.5.3 under linux and
connecting to the database with access on numeric fields.
(using latesest Postgresql odbc driver, .0007)

I don't know if this problem is related to odbc or locale settigs..

When I use the table, Access tell me the numeric filed is a Text
type, but anyway I can retrieve data.

The problem is whan I try to do calculations or assignment: with my
locale setting under windows the decimal point is a comma, so Access
try to insert values like 1234,66 and postgres complains about this
not being a valid numeric representation.

I tried also to set the correct locale under linux, setting LC_*
variables, but it didn't help with using comma instead of point:
pgsql still displays and accept only values like 1234.66

I'm using RedHat 6.1 and postgresql-6.5.3-3 rpms from postgresql.org.

Btw, float are working as expected.

There is a way of telling access "numeric" column is a numeric type?
Or am I doing something wrong?

Thanks in advance.

Ciao,
 Stefano
--------------------------------------------------------------
| Stefano Garavaglia  |  alter.ego@iol.it      ICQ #14209561 | 
| Milano - Italy      |  http://users.iol.it/alter.ego       |
--------------------------------------------------------------