Message-Id: <3.0.32.20000107134923.008f7bc0@ren.cncware.com>
Date: Fri, 07 Jan 2000 13:49:29 -0800
To: Didier Gasser-Morlay <didierg@visualgroup.com>
From: "Ken J. Wright" <ken@ori-ind.com>
Subject: Re: [INTERFACES] ODBC oin Windows
Cc: pgsql-interfaces@postgreSQL.org,
	Byron Nikolaidis <byron.nikolaidis@home.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

At 09:12 01/07/2000 +0000, Didier Gasser-Morlay wrote:
>In a tdbgrid component.

Just to confirm, you're checking the data type by looking at
dbgrid.fields[x].datatype/size?

>I have now tried the Numeric data type (as advised by Michael J davis)
>as in Numeric (10,2). D4 sees it as a char(255) !!!!

This is a driver issue. 
**
Byron, the decimal (numeric) type has never been added to the driver. 
**
Your driver setting is probably set to convert unknowns to maxvarchar,
which the BDE converts to char(255). That's where I don't like the BDE. It
does things for you that you are not aware of. 
Along with the links that Sergio sent, also look at
http://www.odbcexpress.com for an industrial strength odbc api for Delphi.
Not free however.

>I am using PG 6.5.1 should I upgrade to 6.5.3 or to that respect would
>there be NO difference ?

No difference.

Ken
>
>Didier
>
>
>
>"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;
>> 
>> Ken