|
| SQLserver Type | MS-Access | Paradox | dBASE |
| SMALLINT | SHORT | Short | Number (6,10) |
| INTEGER | INTEGER | Long Integer | Number (20,4) |
| DECIMAL(x,y) | DOUBLE | BCD | N/A |
| NUMERIC(x,y) | DOUBLE | Number | Number (x,y) |
| FLOAT(x,y) | DOUBLE | Number | Float (x,y) |
| CHARACTER(n) | TEXT(size) | Alpha | Character |
| VARCHAR(n) | MEMO | Alpha | Character |
| DATE | DATETIME | Date | Date |
| BOOLEAN | BIT or YESNO | Logical | Logical |
| BLOB(n,1) | MEMO | Memo | Memo |
| BLOB(n,2) | N/A | Binary | Binary |
| BLOB(n,3) | N/A | Formatted memo | N/A |
| BLOB(n,4) | N/A | OLE | OLE |
| BLOB(n,5) | N/A | Graphic | N/A |
| TIME | DATETIME | Time | N/A |
| TIMESTAMP | N/A | Timestamp | N/A |
| MONEY | CURRENCY | Money | Number (20,4) |
| AUTOINC | COUNTER | Autoincrement | N/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)
|