RE: [INTERFACES] ODBC oin Windows

Use the numeric data type.  You must have Postgres 6.5 or greater.

Michael J Davis
BackOffice Development, TV Guide Networks
Office:         303-267-6809    Fax: 303-267-6889
Home Office:     303-460-7360    Fax: 303-460-7362
Pager:         303-461-4002
Email:        Michael.J.Davis@tvguide.com


> -----Original Message-----
> From:    Didier Gasser-Morlay [SMTP:didierg@visualgroup.com]
> Sent:    Thursday, January 06, 2000 2:40 AM
> To:    pgsql-interfaces@postgreSQL.org
> Subject:    [INTERFACES] ODBC oin Windows
> 
> 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.
> --------------------------------------------------------------------------
> ------------------
> 
> ************