CompareRDBMS

Type Details for SQL_GUID (-11)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME uniqueidentifier
DATA_TYPE -11
COLUMN_SIZE 36
LITERAL_PREFIX '
LITERAL_SUFFIX '
CREATE_PARAMS
NULLABLE 1
CASE_SENSITIVE 0
SEARCHABLE 2
UNSIGNED_ATTRIBUTE
FIXED_PREC_SCALE 0
AUTO_UNIQUE_VALUE
LOCAL_TYPE_NAME uniqueidentifier
MINIMUM_SCALE
MAXIMUM_SCALE
SQL_DATA_TYPE -11
SQL_DATETIME_SUB
NUM_PREC_RADIX
INTERVAL_PRECISION

Type Details for SQL_WLONGVARCHAR (-10)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME ntext xml
DATA_TYPE -10 -10
COLUMN_SIZE 1073741823 1073741823
LITERAL_PREFIX N' N'
LITERAL_SUFFIX ' '
CREATE_PARAMS
NULLABLE 1 1
CASE_SENSITIVE 0 1
SEARCHABLE 1 0
UNSIGNED_ATTRIBUTE
FIXED_PREC_SCALE 0 0
AUTO_UNIQUE_VALUE
LOCAL_TYPE_NAME ntext xml
MINIMUM_SCALE
MAXIMUM_SCALE
SQL_DATA_TYPE -10 -10
SQL_DATETIME_SUB
NUM_PREC_RADIX
INTERVAL_PRECISION

Type Details for SQL_WVARCHAR (-9)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME nvarchar sysname date time datetime2 datetimeoffset
DATA_TYPE -9 -9 -9 -9 -9 -9
COLUMN_SIZE 4000 128 10 16 27 34
LITERAL_PREFIX N' N' ' ' ' '
LITERAL_SUFFIX ' ' ' ' ' '
CREATE_PARAMS max length
NULLABLE 1 0 1 1 1 1
CASE_SENSITIVE 0 0 0 0 0 0
SEARCHABLE 3 3 3 3 3 3
UNSIGNED_ATTRIBUTE
FIXED_PREC_SCALE 0 0 0 0 0 0
AUTO_UNIQUE_VALUE
LOCAL_TYPE_NAME nvarchar sysname date time datetime2 datetimeoffset
MINIMUM_SCALE
MAXIMUM_SCALE
SQL_DATA_TYPE -9 -9 -9 -9 -9 -9
SQL_DATETIME_SUB
NUM_PREC_RADIX
INTERVAL_PRECISION

Type Details for SQL_WCHAR (-8)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME nchar
DATA_TYPE -8
COLUMN_SIZE 4000
LITERAL_PREFIX N'
LITERAL_SUFFIX '
CREATE_PARAMS length
NULLABLE 1
CASE_SENSITIVE 0
SEARCHABLE 3
UNSIGNED_ATTRIBUTE
FIXED_PREC_SCALE 0
AUTO_UNIQUE_VALUE
LOCAL_TYPE_NAME nchar
MINIMUM_SCALE
MAXIMUM_SCALE
SQL_DATA_TYPE -8
SQL_DATETIME_SUB
NUM_PREC_RADIX
INTERVAL_PRECISION

Type Details for SQL_BIT (-7)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME bit bit bit auto_increment
DATA_TYPE -7 -7 -7
COLUMN_SIZE 1 1 1
LITERAL_PREFIX
LITERAL_SUFFIX
CREATE_PARAMS
NULLABLE 1 1 0
CASE_SENSITIVE 0 0 0
SEARCHABLE 2 3 3
UNSIGNED_ATTRIBUTE 0 0
FIXED_PREC_SCALE 0 0 0
AUTO_UNIQUE_VALUE 0 1
LOCAL_TYPE_NAME bit char(1) char(1) auto_increment
MINIMUM_SCALE 0 0 0
MAXIMUM_SCALE 0 0 0
SQL_DATA_TYPE -7
SQL_DATETIME_SUB 0 0
NUM_PREC_RADIX
INTERVAL_PRECISION 0 0

Type Details for SQL_TINYINT (-6)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME tinyint tinyint identity tinyint tinyint unsigned tinyint unsigned auto_increment tinyint auto_increment
DATA_TYPE -6 -6 -6 -6 -6 -6
COLUMN_SIZE 3 3 3 3 3 3
LITERAL_PREFIX
LITERAL_SUFFIX
CREATE_PARAMS
NULLABLE 1 0 1 1 0 0
CASE_SENSITIVE 0 0 0 0 0 0
SEARCHABLE 2 2 3 3 3 3
UNSIGNED_ATTRIBUTE 1 1 0 1 1 0
FIXED_PREC_SCALE 0 0 0 0 0 0
AUTO_UNIQUE_VALUE 0 1 0 0 1 1
LOCAL_TYPE_NAME tinyint tinyint identity Tiny integer Tiny integer unsigned tinyint unsigned auto_increment tinyint auto_increment
MINIMUM_SCALE 0 0 0 0 0 0
MAXIMUM_SCALE 0 0 0 0 0 0
SQL_DATA_TYPE -6 -6
SQL_DATETIME_SUB 0 0 0 0
NUM_PREC_RADIX 10 10 10 10 10 10
INTERVAL_PRECISION 0 0 0 0

Type Details for SQL_BIGINT (-5)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME bigint bigint identity bigint bigint unsigned bigint auto_increment bigint unsigned auto_increment
DATA_TYPE -5 -5 -5 -5 -5 -5
COLUMN_SIZE 19 19 19 20 19 20
LITERAL_PREFIX
LITERAL_SUFFIX
CREATE_PARAMS
NULLABLE 1 0 1 1 0 0
CASE_SENSITIVE 0 0 0 0 0 0
SEARCHABLE 2 2 3 3 3 3
UNSIGNED_ATTRIBUTE 0 0 0 1 0 1
FIXED_PREC_SCALE 0 0 0 0 0 0
AUTO_UNIQUE_VALUE 0 1 0 0 1 1
LOCAL_TYPE_NAME bigint bigint identity Longlong integer Longlong integer unsigned bigint auto_increment bigint unsigned auto_increment
MINIMUM_SCALE 0 0 0 0 0 0
MAXIMUM_SCALE 0 0 0 0 0 0
SQL_DATA_TYPE -5 -5
SQL_DATETIME_SUB 0 0 0 0
NUM_PREC_RADIX 10 10 10 10 10 10
INTERVAL_PRECISION 0 0 0 0

Type Details for SQL_LONGVARBINARY (-4)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME BLOB BLOB image LONG RAW BLOB BFILE blob mediumblob longblob long varbinary
DATA_TYPE -4 -4 -4 -4 -4 -4 -4 -4 -4 -4
COLUMN_SIZE 2147483647 2147483647 2147483647 2147483647 65535 16777215 2147483647 16777215
LITERAL_PREFIX ' ' 0x ' ' ' ' ' ' 0x
LITERAL_SUFFIX ' ' ' ' ' ' ' '
CREATE_PARAMS
NULLABLE 0 0 1 1 1 1 1 1 1 1
CASE_SENSITIVE 1 1 0 0 1 1 0 0 0 0
SEARCHABLE 1 1 0 0 0 0 3 3 3 3
UNSIGNED_ATTRIBUTE 0 0 0 0 0 0
FIXED_PREC_SCALE 0 0 0 0 0 0 0 0
AUTO_UNIQUE_VALUE 0 0 0 0
LOCAL_TYPE_NAME image LONG RAW BLOB BFILE binary large object (0-65535) binary large object binary large object, use mediumblob instead mediumblob
MINIMUM_SCALE 1 1 0 0 0 0
MAXIMUM_SCALE 999999 999999 0 0 0 0
SQL_DATA_TYPE -4 -4 -4 -4
SQL_DATETIME_SUB 0 0 0 0
NUM_PREC_RADIX
INTERVAL_PRECISION 0 0 0 0

Type Details for SQL_VARBINARY (-3)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME varbinary RAW bytea tinyblob
DATA_TYPE -3 -3 -3 -3
COLUMN_SIZE 8000 2000 1073741824 255
LITERAL_PREFIX 0x ' ' '
LITERAL_SUFFIX ' ' '
CREATE_PARAMS max length max length
NULLABLE 1 1 1 1
CASE_SENSITIVE 0 0 0 0
SEARCHABLE 2 3 3 3
UNSIGNED_ATTRIBUTE 0
FIXED_PREC_SCALE 0 0 0 0
AUTO_UNIQUE_VALUE 0 0
LOCAL_TYPE_NAME varbinary RAW BYTEA binary large object (0-255)
MINIMUM_SCALE 0
MAXIMUM_SCALE 0
SQL_DATA_TYPE -3 -3 -3
SQL_DATETIME_SUB 0
NUM_PREC_RADIX
INTERVAL_PRECISION 0

Type Details for SQL_BINARY (-2)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME binary timestamp
DATA_TYPE -2 -2
COLUMN_SIZE 8000 8
LITERAL_PREFIX 0x 0x
LITERAL_SUFFIX
CREATE_PARAMS length
NULLABLE 1 0
CASE_SENSITIVE 0 0
SEARCHABLE 2 2
UNSIGNED_ATTRIBUTE
FIXED_PREC_SCALE 0 0
AUTO_UNIQUE_VALUE
LOCAL_TYPE_NAME binary timestamp
MINIMUM_SCALE
MAXIMUM_SCALE
SQL_DATA_TYPE -2 -2
SQL_DATETIME_SUB
NUM_PREC_RADIX
INTERVAL_PRECISION

Type Details for SQL_LONGVARCHAR (-1)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME TEXT text LONG CLOB text mediumtext long varchar
DATA_TYPE -1 -1 -1 -1 -1 -1 -1
COLUMN_SIZE 2147483647 2147483647 2147483647 65535 16777215 16777215
LITERAL_PREFIX ' ' ' ' ' ' '
LITERAL_SUFFIX ' ' ' ' ' ' '
CREATE_PARAMS
NULLABLE 0 1 1 1 1 1 1
CASE_SENSITIVE 1 0 1 1 0 0 0
SEARCHABLE 1 1 0 0 3 3 3
UNSIGNED_ATTRIBUTE 0 0 0 0
FIXED_PREC_SCALE 0 0 0 0 0 0
AUTO_UNIQUE_VALUE 0 0 0
LOCAL_TYPE_NAME text LONG CLOB large text object (0-65535) large text object mediumtext
MINIMUM_SCALE 1 0 0 0
MAXIMUM_SCALE 999999 0 0 0
SQL_DATA_TYPE -1 -1 -1
SQL_DATETIME_SUB 0 0 0
NUM_PREC_RADIX
INTERVAL_PRECISION 0 0 0

Type Details for SQL_ALL_TYPES (0)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME VARCHAR CHAR INTEGER REAL BLOB BLOB TEXT sql_variant uniqueidentifier ntext xml nvarchar sysname date time datetime2 datetimeoffset nchar bit tinyint tinyint identity bigint bigint identity image varbinary binary timestamp text char numeric numeric() identity decimal money smallmoney decimal() identity int int identity smallint smallint identity float real varchar datetime smalldatetime LONG RAW RAW LONG CHAR DECIMAL DOUBLE PRECISION DATE VARCHAR2 BLOB BFILE CLOB unknown bytea bpchar numeric numeric int4 int2 float4 float8 int8 date tinterval timestamp text bool array date time timestamp timetz timestamptz varchar decimal tinyint smallint integer float double double timestamp bigint mediumint date time datetime year date enum set blob tinyblob mediumblob longblob char decimal tinyint unsigned smallint unsigned mediumint unsigned int unsigned int integer unsigned bigint unsigned text mediumtext mediumint unsigned auto_increment tinyint unsigned auto_increment smallint auto_increment int unsigned auto_increment mediumint bit numeric integer unsigned auto_increment mediumint unsigned smallint unsigned auto_increment int auto_increment long varbinary double auto_increment double auto_increment integer auto_increment bigint auto_increment bit auto_increment mediumint auto_increment float auto_increment long varchar tinyint auto_increment bigint unsigned auto_increment
DATA_TYPE 12 1 4 7 -4 -4 -1 -150 -11 -10 -10 -9 -9 -9 -9 -9 -9 -8 -7 -6 -6 -5 -5 -4 -3 -2 -2 -1 1 2 2 3 3 3 3 4 4 5 5 6 7 12 93 93 -4 -3 -1 1 3 8 93 12 -4 -4 -1 0 -3 1 3 2 4 5 6 7 8 9 10 11 12 16 50 91 92 93 94 95 12 3 -6 5 4 7 6 8 11 -5 4 9 10 11 5 9 12 12 -4 -3 -4 -4 1 2 -6 5 4 4 4 4 -5 -1 -1 4 -6 5 4 4 -7 2 4 4 5 4 -4 6 8 4 -5 -7 4 7 -1 -6 -5
COLUMN_SIZE 8000 36 1073741823 1073741823 4000 128 10 16 27 34 4000 1 3 3 19 19 2147483647 8000 8000 8 2147483647 8000 38 38 38 19 10 38 10 10 5 5 53 24 8000 23 16 2147483647 2000 2147483647 2000 38 15 19 4000 2147483647 2147483647 2147483647 0 1073741824 1073741824 1000 1000 10 5 6 15 20 10 18 29 1073741824 1 1 10 18 29 29 29 255 15 3 5 10 7 15 15 14 19 8 10 6 21 4 10 255 255 65535 255 16777215 2147483647 255 15 3 5 8 10 10 10 20 65535 16777215 8 3 5 10 7 1 19 10 8 5 10 16777215 15 15 10 19 1 7 7 16777215 3 20
LITERAL_PREFIX ' ' ' ' ' ' N' N' N' N' ' ' ' ' N' 0x 0x 0x 0x ' ' $ $ ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' 0x '
LITERAL_SUFFIX ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' '
CREATE_PARAMS max length length max length length length precision,scale precision precision,scale precision max length max length max length precision,scale max length length precision/scale precision/scale precision/scale precision/scale length max length precision,scale max length precision,scale precision,scale
NULLABLE 0 0 0 0 0 0 0 1 1 1 1 1 0 1 1 1 1 1 1 1 0 1 0 1 1 1 0 1 1 1 0 1 1 1 0 1 0 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 1 1 1 0 1 0 0 1 0 0 0 0 0 0 0 1 0 0
CASE_SENSITIVE 1 1 0 0 1 1 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 1 1 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SEARCHABLE 1 1 1 1 1 1 1 2 2 1 0 3 3 3 3 3 3 3 2 2 2 2 2 0 2 2 2 1 3 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 0 3 0 3 3 3 3 3 0 0 0 0 3 3 2 2 2 2 2 2 2 2 2 2 3 2 2 2 2 2 2 2 3 3 3 3 3 0 3 3 3 3 3 3 3 3 3 3 1 1 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 0 3 3 3
UNSIGNED_ATTRIBUTE 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 1 1 0 0 1 1 0 1 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 1
FIXED_PREC_SCALE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
AUTO_UNIQUE_VALUE 0 1 0 1 0 1 0 0 0 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 0 0 1 0 1 1 0 1 1 1 1 1 1 1 0 1 1
LOCAL_TYPE_NAME sql_variant uniqueidentifier ntext xml nvarchar sysname date time datetime2 datetimeoffset nchar bit tinyint tinyint identity bigint bigint identity image varbinary binary timestamp text char numeric numeric() identity decimal money smallmoney decimal() identity int int identity smallint smallint identity float real varchar datetime smalldatetime LONG RAW RAW LONG CHAR DECIMAL DOUBLE PRECISION DATE VARCHAR2 BLOB BFILE CLOB UNKNOWN BYTEA CHARACTER FLOAT FLOAT INTEGER SMALLINT FLOAT REAL LONGINT DATE TINTERVAL TIMESTAMP TEXT BOOLEAN ARRAY DATE TIME TIMESTAMP TIMETZ TIMESTAMPTZ variable length string double Tiny integer Short integer integer float double double timestamp Longlong integer Medium integer date time datetime year date enum(value1,value2,value3...) set(value1,value2,value3...) binary large object (0-65535) binary large object (0-255) binary large object binary large object, use mediumblob instead string double Tiny integer unsigned Short integer unsigned Medium integer unsigned integer unsigned integer integer Longlong integer unsigned large text object (0-65535) large text object Medium integer unsigned auto_increment tinyint unsigned auto_increment smallint auto_increment integer unsigned auto_increment Medium integer char(1) numeric integer unsigned auto_increment Medium integer unsigned smallint unsigned auto_increment integer auto_increment mediumblob double auto_increment double auto_increment integer auto_increment bigint auto_increment char(1) auto_increment Medium integer auto_increment float auto_increment mediumtext tinyint auto_increment bigint unsigned auto_increment
MINIMUM_SCALE 1 1 0 0 1 1 1 0 0 0 0 0 0 0 0 0 4 4 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
MAXIMUM_SCALE 999999 999999 0 0 999999 999999 999999 0 0 0 0 0 0 38 0 38 4 4 0 0 0 0 0 3 0 38 0 1000 1000 0 0 6 15 0 0 6 6 0 6 6 6 6 0 6 0 0 0 2 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 0 0 0 0 0 4 4 0 0 0 0 2 0 0 0
SQL_DATA_TYPE -150 -11 -10 -10 -9 -9 -9 -9 -9 -9 -8 -7 -6 -6 -5 -5 -4 -3 -2 -2 -1 1 2 2 3 3 3 3 4 4 5 5 6 7 12 9 9 -4 -3 -1 1 3 8 9 12 -4 -4 -1 0 -3 1 3 2 4 5 6 7 8 9 10 11 12 16 50 91 92 93 94 95
SQL_DATETIME_SUB 3 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
NUM_PREC_RADIX 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 2 2 10 10 2 10 10 10 10 2 10 10 10 10 2 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 2 10 10 10 10 10 10 10
INTERVAL_PRECISION 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Type Details for SQL_CHAR (1)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME CHAR char CHAR bpchar char
DATA_TYPE 1 1 1 1 1
COLUMN_SIZE 8000 2000 1073741824 255
LITERAL_PREFIX ' ' ' ' '
LITERAL_SUFFIX ' ' ' ' '
CREATE_PARAMS length max length length max length
NULLABLE 0 1 1 1 1
CASE_SENSITIVE 1 0 1 1 0
SEARCHABLE 1 3 3 3 3
UNSIGNED_ATTRIBUTE 0 0
FIXED_PREC_SCALE 0 0 0 0
AUTO_UNIQUE_VALUE 0 0 0
LOCAL_TYPE_NAME char CHAR CHARACTER string
MINIMUM_SCALE 1 0
MAXIMUM_SCALE 999999 0
SQL_DATA_TYPE 1 1 1
SQL_DATETIME_SUB 0
NUM_PREC_RADIX
INTERVAL_PRECISION 0

Type Details for SQL_NUMERIC (2)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME numeric numeric() identity numeric decimal numeric
DATA_TYPE 2 2 2 2 2
COLUMN_SIZE 38 38 1000 15 19
LITERAL_PREFIX
LITERAL_SUFFIX
CREATE_PARAMS precision,scale precision precision/scale precision,scale precision,scale
NULLABLE 1 0 1 1 1
CASE_SENSITIVE 0 0 0 0 0
SEARCHABLE 2 2 2 3 3
UNSIGNED_ATTRIBUTE 0 0 0 0 0
FIXED_PREC_SCALE 0 0 0 0 0
AUTO_UNIQUE_VALUE 0 1 0 0 0
LOCAL_TYPE_NAME numeric numeric() identity FLOAT double numeric
MINIMUM_SCALE 0 0 0 0 0
MAXIMUM_SCALE 38 0 1000 6 19
SQL_DATA_TYPE 2 2 2
SQL_DATETIME_SUB 0 0
NUM_PREC_RADIX 10 10 2 10
INTERVAL_PRECISION 0 0

Type Details for SQL_DECIMAL (3)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME decimal money smallmoney decimal() identity DECIMAL numeric decimal
DATA_TYPE 3 3 3 3 3 3 3
COLUMN_SIZE 38 19 10 38 38 1000 15
LITERAL_PREFIX $ $
LITERAL_SUFFIX
CREATE_PARAMS precision,scale precision precision,scale precision/scale precision,scale
NULLABLE 1 1 1 0 1 1 1
CASE_SENSITIVE 0 0 0 0 0 0 0
SEARCHABLE 2 2 2 2 3 2 3
UNSIGNED_ATTRIBUTE 0 0 0 0 0 0 0
FIXED_PREC_SCALE 0 1 1 0 0 0 0
AUTO_UNIQUE_VALUE 0 0 0 1 0 0 0
LOCAL_TYPE_NAME decimal money smallmoney decimal() identity DECIMAL FLOAT double
MINIMUM_SCALE 0 4 4 0 0 0 0
MAXIMUM_SCALE 38 4 4 0 38 1000 6
SQL_DATA_TYPE 3 3 3 3 3 3
SQL_DATETIME_SUB 0
NUM_PREC_RADIX 10 10 10 10 10 2
INTERVAL_PRECISION 0

Type Details for SQL_INTEGER (4)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME 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
DATA_TYPE 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4
COLUMN_SIZE 10 10 10 10 8 8 10 10 10 8 10 7 10 8 10 10 7
LITERAL_PREFIX
LITERAL_SUFFIX
CREATE_PARAMS
NULLABLE 0 1 0 1 1 1 1 1 1 1 0 0 1 0 1 0 0 0
CASE_SENSITIVE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SEARCHABLE 1 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3
UNSIGNED_ATTRIBUTE 0 0 0 0 0 0 1 1 0 1 1 1 0 1 1 0 0 0
FIXED_PREC_SCALE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
AUTO_UNIQUE_VALUE 0 1 0 0 0 0 0 0 0 1 1 0 1 0 1 1 1
LOCAL_TYPE_NAME int int identity INTEGER integer Medium integer Medium integer unsigned integer unsigned integer integer Medium integer unsigned auto_increment integer unsigned auto_increment Medium integer integer unsigned auto_increment Medium integer unsigned integer auto_increment integer auto_increment Medium integer auto_increment
MINIMUM_SCALE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
MAXIMUM_SCALE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SQL_DATA_TYPE 4 4 4
SQL_DATETIME_SUB 0 0 0 0 0 0 0 0 0 0 0 0 0 0
NUM_PREC_RADIX 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
INTERVAL_PRECISION 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Type Details for SQL_SMALLINT (5)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME smallint smallint identity int2 smallint year smallint unsigned smallint auto_increment smallint unsigned auto_increment
DATA_TYPE 5 5 5 5 5 5 5 5
COLUMN_SIZE 5 5 5 5 4 5 5 5
LITERAL_PREFIX
LITERAL_SUFFIX
CREATE_PARAMS
NULLABLE 1 0 1 1 1 1 0 0
CASE_SENSITIVE 0 0 0 0 0 0 0 0
SEARCHABLE 2 2 2 3 3 3 3 3
UNSIGNED_ATTRIBUTE 0 0 0 0 0 1 0 1
FIXED_PREC_SCALE 0 0 0 0 0 0 0 0
AUTO_UNIQUE_VALUE 0 1 0 0 0 0 1 1
LOCAL_TYPE_NAME smallint smallint identity SMALLINT Short integer year Short integer unsigned smallint auto_increment smallint unsigned auto_increment
MINIMUM_SCALE 0 0 0 0 0 0 0 0
MAXIMUM_SCALE 0 0 0 0 0 0 0 0
SQL_DATA_TYPE 5 5 5
SQL_DATETIME_SUB 0 0 0 0 0
NUM_PREC_RADIX 10 10 10 10 10 10 10
INTERVAL_PRECISION 0 0 0 0 0

Type Details for SQL_FLOAT (6)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME float float4 double double auto_increment
DATA_TYPE 6 6 6 6
COLUMN_SIZE 53 6 15 15
LITERAL_PREFIX
LITERAL_SUFFIX
CREATE_PARAMS precision/scale
NULLABLE 1 1 1 0
CASE_SENSITIVE 0 0 0 0
SEARCHABLE 2 2 3 3
UNSIGNED_ATTRIBUTE 0 0 0 0
FIXED_PREC_SCALE 0 0 0 0
AUTO_UNIQUE_VALUE 0 0 0 1
LOCAL_TYPE_NAME float FLOAT double double auto_increment
MINIMUM_SCALE 0 0 0
MAXIMUM_SCALE 6 4 4
SQL_DATA_TYPE 6 6
SQL_DATETIME_SUB 0 0
NUM_PREC_RADIX 2 2 2
INTERVAL_PRECISION 0 0

Type Details for SQL_REAL (7)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME REAL real float8 float float auto_increment
DATA_TYPE 7 7 7 7 7
COLUMN_SIZE 24 15 7 7
LITERAL_PREFIX
LITERAL_SUFFIX
CREATE_PARAMS precision/scale
NULLABLE 0 1 1 1 0
CASE_SENSITIVE 0 0 0 0 0
SEARCHABLE 1 2 2 0 0
UNSIGNED_ATTRIBUTE 0 0 0 0 0
FIXED_PREC_SCALE 0 0 0 0
AUTO_UNIQUE_VALUE 0 0 0 1
LOCAL_TYPE_NAME real REAL float float auto_increment
MINIMUM_SCALE 0 0 0 0
MAXIMUM_SCALE 0 15 2 2
SQL_DATA_TYPE 7 7
SQL_DATETIME_SUB 0 0
NUM_PREC_RADIX 2 10 10
INTERVAL_PRECISION 0 0

Type Details for SQL_DOUBLE (8)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME DOUBLE PRECISION int8 double double auto_increment
DATA_TYPE 8 8 8 8
COLUMN_SIZE 15 20 15 15
LITERAL_PREFIX
LITERAL_SUFFIX
CREATE_PARAMS
NULLABLE 1 1 1 0
CASE_SENSITIVE 0 0 0 0
SEARCHABLE 3 2 3 3
UNSIGNED_ATTRIBUTE 0 0 0 0
FIXED_PREC_SCALE 0 0 0 0
AUTO_UNIQUE_VALUE 0 0 0 1
LOCAL_TYPE_NAME DOUBLE PRECISION LONGINT double double auto_increment
MINIMUM_SCALE 0 0 0
MAXIMUM_SCALE 0 4 4
SQL_DATA_TYPE 8 8
SQL_DATETIME_SUB 0 0
NUM_PREC_RADIX 10 10 10
INTERVAL_PRECISION 0 0

Type Details for SQL_DATE (9)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME date date date
DATA_TYPE 9 9 9
COLUMN_SIZE 10 10 10
LITERAL_PREFIX ' ' '
LITERAL_SUFFIX ' ' '
CREATE_PARAMS
NULLABLE 1 1 1
CASE_SENSITIVE 0 0 0
SEARCHABLE 2 3 3
UNSIGNED_ATTRIBUTE 0 0
FIXED_PREC_SCALE 0 0 0
AUTO_UNIQUE_VALUE 0 0 0
LOCAL_TYPE_NAME DATE date date
MINIMUM_SCALE 0 0 0
MAXIMUM_SCALE 0 0 0
SQL_DATA_TYPE 9
SQL_DATETIME_SUB 0 0
NUM_PREC_RADIX
INTERVAL_PRECISION 0 0

Type Details for SQL_TIME (10)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME tinterval time
DATA_TYPE 10 10
COLUMN_SIZE 18 6
LITERAL_PREFIX ' '
LITERAL_SUFFIX ' '
CREATE_PARAMS
NULLABLE 1 1
CASE_SENSITIVE 0 0
SEARCHABLE 2 3
UNSIGNED_ATTRIBUTE 0
FIXED_PREC_SCALE 0 0
AUTO_UNIQUE_VALUE 0 0
LOCAL_TYPE_NAME TINTERVAL time
MINIMUM_SCALE 0 0
MAXIMUM_SCALE 6 0
SQL_DATA_TYPE 10
SQL_DATETIME_SUB 0
NUM_PREC_RADIX
INTERVAL_PRECISION 0

Type Details for SQL_TIMESTAMP (11)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME timestamp timestamp datetime
DATA_TYPE 11 11 11
COLUMN_SIZE 29 14 21
LITERAL_PREFIX ' ' '
LITERAL_SUFFIX ' ' '
CREATE_PARAMS
NULLABLE 1 0 1
CASE_SENSITIVE 0 0 0
SEARCHABLE 2 3 3
UNSIGNED_ATTRIBUTE 0 0
FIXED_PREC_SCALE 0 0 0
AUTO_UNIQUE_VALUE 0 0 0
LOCAL_TYPE_NAME TIMESTAMP timestamp datetime
MINIMUM_SCALE 0 0 0
MAXIMUM_SCALE 6 0 0
SQL_DATA_TYPE 11
SQL_DATETIME_SUB 0 0
NUM_PREC_RADIX
INTERVAL_PRECISION 0 0

Type Details for SQL_VARCHAR (12)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME VARCHAR varchar VARCHAR2 text varchar enum set
DATA_TYPE 12 12 12 12 12 12 12
COLUMN_SIZE 8000 4000 1073741824 255 255 255
LITERAL_PREFIX ' ' ' ' ' ' '
LITERAL_SUFFIX ' ' ' ' ' ' '
CREATE_PARAMS max length max length length max length
NULLABLE 0 1 1 1 1 1 1
CASE_SENSITIVE 1 0 1 1 0 0 0
SEARCHABLE 1 3 3 3 3 1 1
UNSIGNED_ATTRIBUTE 0 0 0 0
FIXED_PREC_SCALE 0 0 0 0 0 0
AUTO_UNIQUE_VALUE 0 0 0 0 0
LOCAL_TYPE_NAME varchar VARCHAR2 TEXT variable length string enum(value1,value2,value3...) set(value1,value2,value3...)
MINIMUM_SCALE 1 0 0 0
MAXIMUM_SCALE 999999 0 0 0
SQL_DATA_TYPE 12 12 12
SQL_DATETIME_SUB 0 0 0
NUM_PREC_RADIX
INTERVAL_PRECISION 0 0 0

Type Details for SQL_BOOLEAN (16)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME bool
DATA_TYPE 16
COLUMN_SIZE 1
LITERAL_PREFIX '
LITERAL_SUFFIX '
CREATE_PARAMS
NULLABLE 1
CASE_SENSITIVE 0
SEARCHABLE 2
UNSIGNED_ATTRIBUTE
FIXED_PREC_SCALE 0
AUTO_UNIQUE_VALUE 0
LOCAL_TYPE_NAME BOOLEAN
MINIMUM_SCALE
MAXIMUM_SCALE
SQL_DATA_TYPE 16
SQL_DATETIME_SUB
NUM_PREC_RADIX
INTERVAL_PRECISION

Type Details for SQL_UDT (17)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_UDT_LOCATOR (18)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_ROW (19)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_REF (20)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_BLOB (30)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_BLOB_LOCATOR (31)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_CLOB (40)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_CLOB_LOCATOR (41)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_ARRAY (50)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME array
DATA_TYPE 50
COLUMN_SIZE 1
LITERAL_PREFIX '
LITERAL_SUFFIX '
CREATE_PARAMS
NULLABLE 1
CASE_SENSITIVE 0
SEARCHABLE 2
UNSIGNED_ATTRIBUTE
FIXED_PREC_SCALE 0
AUTO_UNIQUE_VALUE 0
LOCAL_TYPE_NAME ARRAY
MINIMUM_SCALE
MAXIMUM_SCALE
SQL_DATA_TYPE 50
SQL_DATETIME_SUB
NUM_PREC_RADIX
INTERVAL_PRECISION

Type Details for SQL_ARRAY_LOCATOR (51)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_MULTISET (55)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_MULTISET_LOCATOR (56)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_TYPE_DATE (91)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME date
DATA_TYPE 91
COLUMN_SIZE 10
LITERAL_PREFIX '
LITERAL_SUFFIX '
CREATE_PARAMS
NULLABLE 1
CASE_SENSITIVE 0
SEARCHABLE 2
UNSIGNED_ATTRIBUTE
FIXED_PREC_SCALE 0
AUTO_UNIQUE_VALUE 0
LOCAL_TYPE_NAME DATE
MINIMUM_SCALE 0
MAXIMUM_SCALE 0
SQL_DATA_TYPE 91
SQL_DATETIME_SUB
NUM_PREC_RADIX
INTERVAL_PRECISION

Type Details for SQL_TYPE_TIME (92)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME time
DATA_TYPE 92
COLUMN_SIZE 18
LITERAL_PREFIX '
LITERAL_SUFFIX '
CREATE_PARAMS
NULLABLE 1
CASE_SENSITIVE 0
SEARCHABLE 2
UNSIGNED_ATTRIBUTE
FIXED_PREC_SCALE 0
AUTO_UNIQUE_VALUE 0
LOCAL_TYPE_NAME TIME
MINIMUM_SCALE 0
MAXIMUM_SCALE 6
SQL_DATA_TYPE 92
SQL_DATETIME_SUB
NUM_PREC_RADIX
INTERVAL_PRECISION

Type Details for SQL_TYPE_TIMESTAMP (93)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME datetime smalldatetime DATE timestamp
DATA_TYPE 93 93 93 93
COLUMN_SIZE 23 16 19 29
LITERAL_PREFIX ' ' ' '
LITERAL_SUFFIX ' ' ' '
CREATE_PARAMS
NULLABLE 1 1 1 1
CASE_SENSITIVE 0 0 0 0
SEARCHABLE 3 3 3 2
UNSIGNED_ATTRIBUTE
FIXED_PREC_SCALE 0 0 0 0
AUTO_UNIQUE_VALUE 0 0
LOCAL_TYPE_NAME datetime smalldatetime DATE TIMESTAMP
MINIMUM_SCALE 3 0 0 0
MAXIMUM_SCALE 3 0 0 6
SQL_DATA_TYPE 9 9 9 93
SQL_DATETIME_SUB 3 3 3
NUM_PREC_RADIX
INTERVAL_PRECISION

Type Details for SQL_TYPE_TIME_WITH_TIMEZONE (94)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME timetz
DATA_TYPE 94
COLUMN_SIZE 29
LITERAL_PREFIX '
LITERAL_SUFFIX '
CREATE_PARAMS
NULLABLE 1
CASE_SENSITIVE 0
SEARCHABLE 2
UNSIGNED_ATTRIBUTE
FIXED_PREC_SCALE 0
AUTO_UNIQUE_VALUE 0
LOCAL_TYPE_NAME TIMETZ
MINIMUM_SCALE 0
MAXIMUM_SCALE 6
SQL_DATA_TYPE 94
SQL_DATETIME_SUB
NUM_PREC_RADIX
INTERVAL_PRECISION

Type Details for SQL_TYPE_TIMESTAMP_WITH_TIMEZONE (95)

Detail CSV SQL Server Oracle PostgreSQL SQLite MySQL
TYPE_NAME timestamptz
DATA_TYPE 95
COLUMN_SIZE 29
LITERAL_PREFIX '
LITERAL_SUFFIX '
CREATE_PARAMS
NULLABLE 1
CASE_SENSITIVE 0
SEARCHABLE 2
UNSIGNED_ATTRIBUTE
FIXED_PREC_SCALE 0
AUTO_UNIQUE_VALUE 0
LOCAL_TYPE_NAME TIMESTAMPTZ
MINIMUM_SCALE 0
MAXIMUM_SCALE 6
SQL_DATA_TYPE 95
SQL_DATETIME_SUB
NUM_PREC_RADIX
INTERVAL_PRECISION

Type Details for SQL_INTERVAL_YEAR (101)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_INTERVAL_MONTH (102)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_INTERVAL_DAY (103)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_INTERVAL_HOUR (104)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_INTERVAL_MINUTE (105)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_INTERVAL_SECOND (106)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_INTERVAL_YEAR_TO_MONTH (107)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_INTERVAL_DAY_TO_HOUR (108)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_INTERVAL_DAY_TO_MINUTE (109)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_INTERVAL_DAY_TO_SECOND (110)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_INTERVAL_HOUR_TO_MINUTE (111)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_INTERVAL_HOUR_TO_SECOND (112)

This type is not supported by any of the configured RDBMSs

Type Details for SQL_INTERVAL_MINUTE_TO_SECOND (113)

This type is not supported by any of the configured RDBMSs

Please return to the Home Page