🚀 go-pugleaf

On Fri, 21 Aug 1998 08:48:15 -0600, "Dave Durland"
<david.durland@cvg-grp.com> wrote:

>Does anyone have a list of dBase datatypes and how they should translate to
>Oracle7 datatypes?
>(I'm not sure which version of dBase is being used.  This is for a data
>conversion project still being planned.)
>
>Specifically, looking for definitions and possible conversions from dBase's
>datatypes(at least this is what I'm being given):
>  C(n)
>  L
>  F
>  I
>  D

If you have SQL Links, there are lists comparing dBASE and Paradox column
specifications to those for a variety of SQL table types (InterBase,
Informix, Oracle, Sybase, SQL Server, and DB/2). Look in the SQL Links
online help file, SQLLNK32.HLP, found in the main BDE directory. In the
table of contents, expand the book "Configuring and connecting to SQL
servers". This displays a sub-book for each of the covered SQL database
types. Each sub-book has a topic named "<database type> data type
translations" (where <database type> is an actual SQL database system
name).

In case you do not have this file...

  FROM: dBASE   TO: ORACLE    TO: Paradox
  -----------   -----------   -----------------
  Character     VARCHAR2(n)   Alphanumeric(n)
  Number1       NUMBER        Short, Number
  Float         NUMBER        Short, Number
  Date          DATE          Date
  Logical       CHAR(1)       Bool
  Memo          LONG          Memo
  Bytes         LONG RAW      Bytes
  Lock	        CHAR(24)      Alphanumeric {24}

//////////////////////////////////////////////////////////////////////////
Steve Koterski                      "The knowledge of the world is only to
Technical Publications              be acquired in the world, and not in a
INPRISE Corporation                 closet."
http://www.inprise.com/delphi          -- Earl of Chesterfield (1694-1773)