Message-Id: <3556F090.A50BC11D@insightdist.com>
Date: Mon, 11 May 1998 08:35:29 -0400
From: Byron Nikolaidis <byronn@insightdist.com>
Mime-Version: 1.0
To: "Jose' Soares Da Silva" <sferac@bo.nettuno.it>
Cc: interfaces postgres <pgsql-interfaces@PostgreSQL.org>
Subject: Re: NEW ODBC DRIVER
References: <Pine.LNX.3.96.980511131010.1267A-100000@proxy.bazzanese.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Jose' Soares Da Silva wrote:

> I have a problem with types.
> I created a table with a column of type money and another with type
> bool, Access translate money to numeric (double precision) and bool to
> text.
> I thought that Access recognized this types as Money and Yes/No.
> Is it an ODBC or a PostgreSQL problem ?
>                                                          Thanks, Jose'


In my tests, Access never bothered to retrieve the information returned by
the driver which says that the field is a MONEY type.  I chose to make it a
numeric, but I could make it character, which would allow you to see the
money symbols, but I'm not sure if you could perform calculations on it?

As for the BOOL problem, I tried to return it as a SQL_BOOL, but Access
displayed it as 0=FALSE, and (-1)=TRUE.  Why does TRUE translate to a -1, I
have no idea.  But for that reason, I chose to make it a character type
instead.

I could add options to the setup dialog for handling these two types, if
anyone's interested.

Byron