| (-150) |
|
sql_variant |
|
|
|
|
| SQL_GUID (-11) |
|
uniqueidentifier |
|
|
|
|
| SQL_WLONGVARCHAR (-10) |
|
ntext, xml |
|
|
|
|
| SQL_WVARCHAR (-9) |
|
nvarchar, sysname, date, time, datetime2, datetimeoffset |
|
|
|
|
| SQL_WCHAR (-8) |
|
nchar |
|
|
|
|
| SQL_BIT (-7) |
|
bit |
|
|
|
bit, bit auto_increment |
| SQL_TINYINT (-6) |
|
tinyint, tinyint identity |
|
|
|
tinyint, tinyint unsigned, tinyint unsigned auto_increment, tinyint auto_increment |
| SQL_BIGINT (-5) |
|
bigint, bigint identity |
|
|
|
bigint, bigint unsigned, bigint auto_increment, bigint unsigned auto_increment |
| SQL_LONGVARBINARY (-4) |
BLOB, BLOB |
image |
LONG RAW, BLOB, BFILE |
|
|
blob, mediumblob, longblob, long varbinary |
| SQL_VARBINARY (-3) |
|
varbinary |
RAW |
bytea |
|
tinyblob |
| SQL_BINARY (-2) |
|
binary, timestamp |
|
|
|
|
| SQL_LONGVARCHAR (-1) |
TEXT |
text |
LONG, CLOB |
|
|
text, mediumtext, long varchar |
| SQL_ALL_TYPES (0) |
|
|
|
unknown |
|
|
| SQL_CHAR (1) |
CHAR |
char |
CHAR |
bpchar |
|
char |
| SQL_NUMERIC (2) |
|
numeric, numeric() identity |
|
numeric |
|
decimal, numeric |
| SQL_DECIMAL (3) |
|
decimal, money, smallmoney, decimal() identity |
DECIMAL |
numeric |
|
decimal |
| SQL_INTEGER (4) |
INTEGER |
int, int identity |
|
int4 |
|
integer, mediumint, mediumint unsigned, int unsigned, int, integer unsigned, mediumint unsigned auto_increment, int unsigned auto_increment, mediumint, integer unsigned auto_increment, mediumint unsigned, int auto_increment, integer auto_increment, mediumint auto_increment |
| SQL_SMALLINT (5) |
|
smallint, smallint identity |
|
int2 |
|
smallint, year, smallint unsigned, smallint auto_increment, smallint unsigned auto_increment |
| SQL_FLOAT (6) |
|
float |
|
float4 |
|
double, double auto_increment |
| SQL_REAL (7) |
REAL |
real |
|
float8 |
|
float, float auto_increment |
| SQL_DOUBLE (8) |
|
|
DOUBLE PRECISION |
int8 |
|
double, double auto_increment |
| SQL_DATE (9) |
|
|
|
date |
|
date, date |
| SQL_TIME (10) |
|
|
|
tinterval |
|
time |
| SQL_TIMESTAMP (11) |
|
|
|
timestamp |
|
timestamp, datetime |
| SQL_VARCHAR (12) |
VARCHAR |
varchar |
VARCHAR2 |
text |
|
varchar, enum, set |
| SQL_BOOLEAN (16) |
|
|
|
bool |
|
|
| SQL_ARRAY (50) |
|
|
|
array |
|
|
| SQL_TYPE_DATE (91) |
|
|
|
date |
|
|
| SQL_TYPE_TIME (92) |
|
|
|
time |
|
|
| SQL_TYPE_TIMESTAMP (93) |
|
datetime, smalldatetime |
DATE |
timestamp |
|
|
| SQL_TYPE_TIME_WITH_TIMEZONE (94) |
|
|
|
timetz |
|
|
| SQL_TYPE_TIMESTAMP_WITH_TIMEZONE (95) |
|
|
|
timestamptz |
|
|