Message-ID: <38755B8E.F74BA7E9@perio.unlp.edu.ar>
Date: Fri, 07 Jan 2000 00:20:46 -0300
From: "Sergio A. Kessler" <ser@perio.unlp.edu.ar>
MIME-Version: 1.0
To: "Ken J. Wright" <ken@ori-ind.com>
CC: Didier Gasser-Morlay <didierg@visualgroup.com>,
	pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC oin Windows
References: <3.0.32.20000106105502.009194e0@ren.cncware.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

"Ken J. Wright" wrote:
> 
> >1. Money type is seen has a float. Delphi complains when trying to post
> 
> Use the decimal type from 6.5.x
> 
> >2. Int8 is seen as a 17 byte string
> >3. float4 is seens as using 8 bytes (as float8)
> 
> How are you viewing this data? Delphi provides casting methods
> (AsString,AsFloat,etc) to convert  a fields raw data to an appropriate data
> type for your app.
> 
> f := Dataset.FieldByName('SomeField').AsFloat;

if you are using Delphi, maybe you want to check the Export
utility in http://sak.org.ar, it takes any database supported 
by the BDE and translate it to sql scripts (I've used it many 
times to convert db's to Postgres)

and while we are on the subject, you may want to check mOdbc
http://perio.unlp.edu.ar/modbc (native odbc components for
Delphi and BCBuilder, no mo BDE)
I'm using it with Postgres for years now.

all of this is free software, of course ...

(beware, the connection is f* slow, as a adsl modem stopped
to work the past weekend, Y2K bug ?)

-- 
-=  Sergio A. Kessler     ==    http://sak.org.ar  =-
You can have it soon, cheap and working; choose *two*.