|
|
Datatypes are easier to remember than functions, but knowing the equivalents across several systems can be difficult, if not impossible, for most of us. Unfortunately, if you guess the wrong datatype, you can actually destroy data; so it's important that you have the most precise match possible.
Category | SQL Server | Access | Oracle | MySQL |
---|---|---|---|---|
Binary | BINARY | RAW | BINARY | |
VARBINARY | ||||
Text/Character | CHAR | CHAR | CHAR | |
VARCHAR | TEXT | VARCHAR | VARCHAR | |
NCHAR | NCHARN | |||
NTEXT | NCLOB | |||
NVARCHAR | NVARCHAR | |||
TEXT | MEMO | CLOB | ||
TINYTEXT, | ||||
TINYBLOB | ||||
TEXT, BLOB | ||||
MEDIUMTEXT, MEDIUMBLOB | ||||
BIGTEXT, BIGBLOB | ||||
Numeric | BIT | YES/NO | BIT, TINYINT | |
BITNULL | ||||
NUMERIC | NUMBER | |||
NULLDECIMAL | ||||
DECIMAL | DECIMAL | DECIMAL | ||
DECIMAL NULL | ||||
REAL | FieldSize = Single | DOUBLE | ||
FLOAT | FieldSize = Double | FLOAT | ||
REAL NULL | ||||
FLOAT NULL | ||||
TINYINT | FieldSize = Byte | TINYINT | ||
Numeric (cont.) | SMALLINT | FieldSize = Integer | SMALLINT | |
INT | FieldSize = Long | INT | ||
TINYINT NULL | ||||
SMALLINT NULL | ||||
INT NULL | ||||
MEDIUMINTBIGINT | ||||
Date/Time | DATETIME | DATE/TIME | DATE | DATETIME |
SMALLDATETIME | DATE | |||
D ATETIME NULL | ||||
TIMETIMESTAMP | TIMESTAMP | |||
INTERVAL | YEAR | |||
Currency/Money | SMALLMONEY | CURRENCY | ||
MONEY | ||||
SMALLMONEY NULL | ||||
MONEY NULL | ||||
Image | IMAGE | OLE OBJECT | ||
BFILE |
|
|