From: Byron Nikolaidis <byronn@insightdist.com>
To: Jose' Soares Da Silva <sferac@bo.nettuno.it>
Cc: interfaces postgres <pgsql-interfaces@PostgreSQL.org>
Subject: Re: NEW ODBC DRIVER
Date: Mon, 11 May 1998 08:35:29 -0400
Message-ID: <3556F090.A50BC11D@insightdist.com> (raw)
References: <Pine.LNX.3.96.980511131010.1267A-100000@proxy.bazzanese.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, sferac@bo.nettuno.it
Subject: Re: NEW ODBC DRIVER
In-Reply-To: <3556F090.A50BC11D@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox