From: Didier Gasser-Morlay <didierg@visualgroup.com>
To: pgsql-interfaces@postgresql.org
Subject: ODBC oin Windows
Date: Thu, 06 Jan 2000 09:39:51 +0000
Message-ID: <387462E7.E46F3B4A@visualgroup.com> (raw)
I have downloaded and happilly installed the odbc driver for Windows
from insightdist.com
I am using Delphi 4 SP3 on Windows NT 4 SP3 and I have the following
questions/problems
1. Money type is seen has a float. Delphi complains when trying to post
a float into a money
2. Int8 is seen as a 17 byte string
3. float4 is seens as using 8 bytes (as float8)
4. Since the money type is not recommended, I was planning to store
money amount in int8 forcing the number of decimals to a known number.
Since delphi sees int8 as a string this makes life a bit tricky,
especially doing calculations. How do you store large money amounts (4
bytes when you store e.g. italian Lira or Spanish Pesetas is a bit
small)
Any ideas ?
Didier
--
--------------------------------------------------------------------------------------------
Any views or opinions are solely those of the author and do not
necessarily
represent those of Visual Communications Group or its principal
operating
divisions (FPG, Telegraph Colour Library, Planet Earth Pictures,
Colorific!, Pix, Giraudon, Bavaria Bildagentur).
--------------------------------------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which
it is addressed, and may contain confidential and/or privileged
material.
If you are not the intended recipient of this message, please do not
read,
copy, use or disclose this communication; and please notify the sender
immediately. It should be noted that any review, retransmission,
dissemination or other use of, or taking action in reliance upon, this
information by persons or entities other than the intended recipient is
prohibited.
--------------------------------------------------------------------------------------------
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: didierg@visualgroup.com
Subject: Re: ODBC oin Windows
In-Reply-To: <387462E7.E46F3B4A@visualgroup.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