Received: from cncware.whidbey.com (IDENT:root@cncware.whidbey.com [208.25.171.37]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA40100 for ; Thu, 6 Jan 2000 13:54:05 -0500 (EST) (envelope-from ken@ori-ind.com) Received: from ken (ken.cncware.com [192.168.61.201]) by cncware.whidbey.com (8.9.3/8.9.3) with SMTP id LAA09869; Thu, 6 Jan 2000 11:01:53 -0800 Message-Id: <3.0.32.20000106105502.009194e0@ren.cncware.com> X-Sender: ken_ori@ren.cncware.com X-Mailer: Windows Eudora Pro Version 3.0 (32) Date: Thu, 06 Jan 2000 10:55:07 -0800 To: Didier Gasser-Morlay , pgsql-interfaces@postgreSQL.org From: "Ken J. Wright" Subject: Re: [INTERFACES] ODBC oin Windows Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >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