🚀 go-pugleaf

In article <6rk19s$5172@forums.borland.com>, david.durland@cvg-grp.com 
grudgingly admits...
> 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
> 
SQL syntax	DB	DBF 7	DBF 5
SMALLINT	Short	Long	Numeric (6,10)
INTEGER	Long Integer	Long	Numeric (20,4)
DECIMAL(x,y)	BCD	Numeric (x,y)	N/A
NUMERIC(x,y)	Number	Numeric (x,y)	Numeric (x,y)
FLOAT(x,y)	Number	Double	Float (x,y)
CHARACTER(n)	Alpha	Character (n)	Character (n)
VARCHAR(n)	Alpha	Character (n)	Character (n)
DATE	Date	Date	Date
BOOLEAN	Logical	Logical	Logical
BLOB(n,1)	Memo	Memo	Memo
BLOB(n,2)	Binary	Binary	Binary
BLOB(n,3)	Formatted memo	N/A	N/A
BLOB(n,4)	OLE	OLE	OLE
BLOB(n,5)	Graphic	N/A	N/A
TIME	Time	N/A	N/A
TIMESTAMP	Timestamp	Timestamp	N/A
MONEY	Money	Numeric (20,4)	Numeric (20,4)
AUTOINC	Autoincrement	Autoincrement	N/A
BYTES(n)	Bytes	N/A	N/A
x = precision (default: specific to driver)
y = scale (default: 0)
n = length in bytes (default: 0)
1�5 = BLOB subtype (default: 1)
-- 
Romain Strieff [TeamB]