| bigint |
DECIMAL |
bigint |
| binary(n) |
BINARY(n) |
bytea(n) |
| bit |
BIT |
boolean, bool |
| char(n) |
CHAR(n) |
char(n) |
| datetime |
DATETIME |
timestamp(date, time) |
| decimal |
DECIMAL |
decimal |
| float |
FLOAT |
real, float4 |
| image |
IMAGE |
bytea |
| int |
INT |
integer, int, int4 |
| money |
CURRENCY |
decimal |
| nchar(n) |
NCHAR(n) |
char(n) |
| ntext |
LONGTEXT |
text |
| numeric |
DECIMAL |
numeric |
| nvarchar(n) |
NCHAR VARYING(n) |
varchar(n) |
| real |
REAL |
real |
| smalldatetime |
DATETIME |
timestamp(date, time) |
| smallint |
SMALLINT |
smallint, int2 |
| smallmoney |
CURRENCY |
decimal |
| text |
LONGTEXT |
text |
| timestamp |
BINARY |
无 |
| tinyint |
BYTE |
无 |
| uniqueidentifier |
GUID |
无 |
| varbinary(n) |
VARBINARY(n) |
bytea(n) |
| varchar(n) |
VARCHAR(n) |
varchar(n) |