Data Structures > Data type translations

When a table is copied or appended to a table of a different driver type, data type translations take place according to the following tables. (You can widen this Help window to display the full width of the chart.)

Note:

FoxPro uses the same data type translations as dBASE. MS SQL uses the same data type translations as Sybase.

From Paradox	To dBASE	To Oracle	To Sybase	To InterBase	To Informix
Alpha	Character	VarChar	VarChar	Varying	VarChar
Number	Float {20.4}	Number	Float	Double	Float
Money	Number {20.4}	Number	Money	Double	Money {16.2}
Date	Date	Time	DateTime	Date	Date
Short	Number {6.0}	Number	SmallInt	Short	SmallInt
Memo	Memo	Long	Text	Blob/1	Text
Binary	Memo	LongRaw	Image	Blob	Byte
Formatted memo	Memo	LongRaw	Image	Blob	Byte
OLE	OLE	LongRaw	Image	Blob	Byte
Graphic	Binary	LongRaw	Image	Blob	Byte
Long	Long	Number	Int	Long	Integer
Time	Character {>8}	Character {>8}	Character {>8}	Character {>8}	Character {>8}
DateTime	Date Time	Date	DateTime	Date	DateTime
Bool	Bool	Character {1}	Bit	Character {1}	Character
AutoInc	AutoInc	Number	Int	Long	Integer
Bytes	Memo	LongRaw	Image	Varying	Byte
BCD	N/A	N/A	N/A	N/A	N/A

From Access	To Paradox	To dBASE	To InterBase
Autoincrement	Autoincrement	Numeric	Long
Bit	Logical	Logical	VarChar
Byte	Number	Numeric	Long
Char	Alpha	Character	VarChar
DateTime	Timestamp	DateTime	Date
Double	Number	Double	Double
Float	Number	Double/Float	Double
Long	Long	Numeric	Long
LongBinary	Binary	Ole	N/A
LongText	Memo	Memo	Text Blob
Money	Money	Numeric	Double
Short	Short	Numeric	Short
VarChar	Alpha	Character	VarChar

From Access	To Oracle	To Sybase	To Informix
Autoincrement	Number	Int	Integer
Bit	VarChar2	Bit	VarChar
Byte	Number	Int	Integer
Char	VarChar2	Char	VarChar
DateTime	Date DateTime	DateTime	DateTime
Double	N/A	Float	Float
Float	Number	Float	Float
Long	Number	Int	Integer
LongBinary	Number	Image	Byte
LongText	Long	Text	Text
Money	Number	Money	Money
Short	Number	SmallInt	SmallInt
VarChar	VarChar2	Char	VarChar

From dBASE	To Paradox	To Oracle	To Sybase	To InterBase	To Informix
Character	Alpha	Character	VarChar	Varying	VarChar
Number, iUnits1 < 5 & iUnits2 = 0	Short	Number	SmallInt	Short	SmallInt
Number, others	Number	Number	Float	Double	Float
Float	Number	Number	Float	Double	Float
Date	Date	DateTime	Date	Date
Memo	Memo	Long	Text	Blob/1	Text
Bool	Bool	Character {1}	Bit	Character {1}	Character
Lock	Alpha {24}	Character {24}	Character {24}	Character {24}	Character
OLE	OLE	LongRaw	Image	Blob	Byte
Binary	Binary	LongRaw	Image	Blob	Byte
Bytes	Bytes	LongRaw	Image	Blob (temp tables only)	Byte
Long	Long	Number	Int		Integer
DateTime	DateTime	DateTime	DateTime	Date	DateTime
Double	Number	N/A	Float	Double	Float
AutoInc	AutoInc	Number	Int	Long	Integer

From Oracle	To Paradox	To dBASE	To Sybase	To InterBase	To Informix
Character	Alpha	Character	VarChar	Varying	Character
Raw	Number	Float {20.4}	Float	Double	Float
Date	DateTime	Date	DateTime	Date	DateTime
Number	Number	Double	Float	Double	Float
Long	Memo	Memo	Text	Blob/1	Text
LongRaw	Binary	Memo	Image	Varying	Byte

From Sybase	To Paradox	To dBASE	To Oracle	To InterBase	To Informix
Character	Alpha	Character	Character	Varying	Character
Var Character	Alpha	Character	Character	Varying	Character
Int	Number	Number {11.0}	Number	Long	Integer
Small Int	Short	Number {6.0}	Number	Short	SmallInt
Tiny Int	Short	Number {6.0}	Number	Short	SmallInt
Float	Number	Double	Number	Double	Float
Money	Money	Number {20.4}	Number	Double	Money {16.2}
Text	Memo	Memo	Long	Blob/1	Text
Binary	Binary	Memo	Raw	Varying	VarChar
Var Binary	Binary	Memo	Raw	Varying	VarChar
Image	Binary	Memo	LongRaw	Blob	Byte
Bit	Alpha	Bool	Character	Varying	Character
DateTime	DateTime	DateTime	Date	Date	DateTime
TimeStamp	Binary	Memo	Raw	Varying	VarChar
Float4	Number	Double	Number	Double	Float
Money4	Money	Number {20.4}	Number	Double	Money {16.2}
DateTime4	DateTime	DateTime	Date	Date	DateTime

From InterBase	To Paradox	To dBASE	To Oracle	To Sybase	To Informix
Short	Short	Number {6.0}	Number	Small Int	SmallInt
Long	Number	Number {11.0}	Number	Int	Integer
Float	Number	Float {20.4}	Number	Float	Float
Double	Number	Float {20.4}	Number	Float	Float
Char	Alpha	Character	Character	VarChar	Character
Varying	Alpha	Character	Character	VarChar	Character
wDate	DateTime	Date	Date	DateTime	DateTime
Blob	Binary	Memo	LongRaw	Image	Byte
Blob/1	Memo	Memo	Long	Text	Text

From Informix	To Paradox	To dBASE	To Oracle	To Sybase	To InterBase
Char	Alpha	Character	Character	VarChar	Varying
Smallint	Short	Number {6.0}	Number	Small Int	Short
Integer	Number	Number {11.0}	Number	Int	Long
Smallfloat	Number	Float {20.4}	Number	Float	Double
Float	Number	Float {20.4}	Number	Float	Double
Money	Money	Number {20.4}	Number	Float	Double
Decimal	Number	Float	Number	Float	Double
Date	Date	Date	Date	DateTime	Date
Datetime	DateTime	Date	Date	DateTime	Date
Interval	Alpha	Character	Character	VarChar	Varying
Serial	Number	Number {11.0}	Number	Int	Long
Byte	Binary	Memo	LongRaw	Image	Blob
Text	Memo	Memo	Long	Text	Blob/1
VarChar	Alpha	Character	Character	VarChar	Varying