SQL simple -> Selected datatype formats for desktop DBMS

SQLserver TypeMS-AccessParadoxdBASE
SMALLINTSHORTShortNumber (6,10)
INTEGER INTEGER Long IntegerNumber (20,4)
DECIMAL(x,y)DOUBLEBCD N/A
NUMERIC(x,y)DOUBLENumber Number (x,y)
FLOAT(x,y) DOUBLENumberFloat (x,y)
CHARACTER(n)TEXT(size)AlphaCharacter
VARCHAR(n)MEMOAlphaCharacter
DATE DATETIMEDate Date
BOOLEAN BIT or YESNOLogical Logical
BLOB(n,1)MEMOMemo Memo
BLOB(n,2)N/ABinary Binary
BLOB(n,3)N/AFormatted memoN/A
BLOB(n,4)N/AOLE OLE
BLOB(n,5)N/AGraphic N/A
TIME DATETIMETimeN/A
TIMESTAMPN/ATimestampN/A
MONEYCURRENCYMoneyNumber (20,4)
AUTOINCCOUNTERAutoincrementN/A
BYTES(n)BINARY(size)Bytes N/A

x = precision (default: specific to driver)
y = scale (default: 0)
n = length in bytes (default: 0)
1-5 = BLOB subtype (default: 1)

There are lot of synonims for different Access datatypes:

TEXT(50) is same as CHAR(50)
MEMO = LONGTEXT (string up to 1.2 gigabytes)
LONG = INTEGER (integer number (4 bytes))
COUNTER = Autoincrement (integer automaticaly incremented for each new record)


sqlexamples.info