ID                                   StandardSQL                          DB2                                  H2                                   HSQLDB                               MSAccess                             MySQL                                Oracle                               PostgreSQL                           SQLite                               SQLServer                            SQLServer 2008

character(n)                         char(n)                              char(n)                              char(n)                              char(n)                              text                                 char(n)                              char(n)                              char(n)                              text                                 char(n)                              char(n)
varchar(n)                           varchar(n)                           varchar(n)                           varchar(n)                           varchar(n)                           text                                 varchar(n)                           varchar2(n)                          varchar(n)                           text                                 varchar(n)                           varchar(n)
nchar(n)                             nchar(n)                             graphic(n)                           char(n)                              char(n)                              text                                 char(n)                              nchar(n)                             char(n)                              text                                 nchar(n)                             nchar(n)
nvarchar(n)                          nvarchar(n)                          vargraphic(n)                        varchar(n)                           varchar(n)                           text                                 varchar(n)                           nvarchar2(n)                         varchar(n)                           text                                 nvarchar(n)                          nvarchar(n)
decimal                              decimal                              decimal                              decimal                              decimal                              decimal                              decimal                              number                               decimal                              numeric                              decimal                              decimal
decimal(p)                           decimal(p)                           decimal(p)                           decimal(p)                           decimal(p)                           decimal                              decimal(p)                           number(p)                            decimal(p)                           numeric                              decimal(p)                           decimal(p)
decimal(p,s)                         decimal(p,s)                         decimal(p,s)                         decimal(p,s)                         decimal(p,s)                         decimal                              decimal(p,s)                         number(p,s)                          decimal(p,s)                         numeric                              decimal(p,s)                         decimal(p,s)
numeric                              numeric                              numeric                              numeric                              numeric                              decimal                              numeric                              number                               numeric                              numeric                              numeric                              numeric
numeric(p)                           numeric(p)                           numeric(p)                           numeric(p)                           numeric(p)                           decimal                              numeric(p)                           number(p)                            numeric(p)                           numeric                              numeric(p)                           numeric(p)
numeric(p,s)                         numeric(p,s)                         numeric(p,s)                         numeric(p,s)                         numeric(p,s)                         decimal                              numeric(p,s)                         number(p,s)                          numeric(p,s)                         numeric                              numeric(p,s)                         numeric(p,s)
integer                              integer                              int                                  int                                  int                                  long                                 int                                  number(10,0)                         int                                  integer                              int                                  int
smallint                             smallint                             smallint                             smallint                             smallint                             smallint                             smallint                             number(5,0)                          smallint                             integer                              smallint                             smallint
float                                float                                decfloat                             float                                float                                double                               float                                float                                float                                real                                 float                                float
double precision                     double                               double                               double                               double                               double                               double                               float(24)                            double precision                     real                                 float(53)                            float(53)
real                                 real                                 real                                 real                                 real                                 real                                 real                                 float(24)                            real                                 real                                 real                                 real
text                                 text                                 clob                                 clob                                 clob                                 text                                 text                                 clob                                 text                                 text                                 text                                 text
clob                                 clob                                 clob                                 clob                                 clob                                 memo                                 text                                 clob                                 text                                 text                                 text                                 text
clob(n)                              clob(n)                              clob(n)                              clob(n)                              clob(n)                              memo                                 text                                 clob                                 text                                 text                                 text                                 text
nclob                                nclob                                clob                                 clob                                 clob                                 memo                                 text                                 nclob                                text                                 text                                 ntext                                ntext
ntext                                ntext                                clob                                 clob                                 clob                                 text                                 text                                 nclob                                text                                 text                                 ntext                                ntext
varchar                              varchar                              varchar(n)                           varchar                              varchar                              text                                 varchar(n)                           varchar2(n)                          varchar                              text                                 varchar(max)                         varchar(max)
varchar_ignorecase                   varchar                              varchar(n)                           varchar_ignorecase                   varchar_ignorecase                   text                                 varchar(n)                           varchar2(n)                          varchar                              text                                 varchar(max)                         varchar(max)
varchar_ignorecase(n)                varchar(n)                           varchar(n)                           varchar_ignorecase(n)                varchar_ignorecase(n)                text                                 varchar(n)                           varchar2(n)                          varchar(n)                           text                                 varchar(n)                           varchar(n)
nvarchar                             nvarchar                             vargraphic(n)                        varchar                              varchar                              text                                 varchar(n)                           nvarchar2(n)                         varchar                              text                                 nvarchar(max)                        nvarchar(max)
blob                                 blob                                 blob                                 blob                                 blob                                 longbinary                           blob                                 blob                                 bytea                                none                                 varbinary(max)                       varbinary(max)
blob(n)                              blob(n)                              blob(n)                              blob(n)                              blob(n)                              longbinary                           blob                                 blob                                 bytea                                none                                 varbinary(n)                         varbinary(n)
bfile                                blob                                 blob                                 blob                                 blob                                 longbinary                           blob                                 bfile                                bytea                                none                                 varbinary(max)                       varbinary(max)
varbinary                            varbinary                            varchar(n) for bit data              varbinary                            varbinary                            longbinary                           varbinary(n)                         blob                                 bytea                                none                                 varbinary(max)                       varbinary(max)
varbinary(n)                         varbinary(n)                         varchar(n) for bit data              varbinary(n)                         varbinary(n)                         longbinary                           varbinary(n)                         blob                                 bytea                                none                                 varbinary(n)                         varbinary(n)
array                                □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□
bigint                               bigint                               bigint                               bigint                               bigint                               long                                 bigint                               number(19,0)                         bigint                               integer                              bigint                               bigint
bigint(n)                            bigint                               bigint                               bigint                               bigint                               long                                 bigint(n)                            number(19,0)                         bigint                               integer                              bigint                               bigint
bigserial                            bigint                               bigint                               bigint                               bigint                               counter                              bigint                               number(19,0)                         bigserial                            integer                              bigint                               bigint
binary_double                        double                               double                               double                               double                               double                               double                               binary_double                        double precision                     real                                 float(53)                            float(53)
binary_float                         float                                decfloat                             float                                float                                double                               float                                binary_float                         float                                real                                 float                                float
binary(n)                            binary(n)                            char(n) for bit data                 binary                               binary                               longbinary                           binary(n)                            raw(n)                               bytea                                none                                 binary(n)                            binary(n)
binary1                              binary                               char for bit data                    binary                               binary                               longbinary                           binary                               raw(1)                               bytea                                none                                 binary                               binary
bit                                  bit                                  char(1)                              bit                                  bit                                  yesno                                bit(1)                               char(1)                              bit                                  text                                 bit                                  bit
bit(n)                               bit(n)                               char(n)                              char(n)                              char(n)                              text                                 bit(n)                               char(n)                              bit(n)                               text                                 char(n)                              char(n)
bit varying                          bit varying                          varchar(n)                           varchar                              varchar                              text                                 text                                 varchar2(n)                          bit varying                          text                                 varchar(max)                         varchar(max)
bit varying(n)                       bit varying(n)                       varchar(n)                           varchar(n)                           varchar(n)                           text                                 varchar(n)                           varchar2(n)                          bit varying(n)                       text                                 varchar(n)                           varchar(n)
boolean                              boolean                              char(1)                              boolean                              boolean                              yesno                                boolean                              char(1)                              boolean                              text                                 bit                                  bit
box                                  □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               box                                  none                                 □□□□□□                               □□□□□□
char                                 char                                 char                                 char                                 char                                 text                                 char                                 char                                 char                                 text                                 char                                 char
nchar                                nchar                                graphic                              char                                 char                                 text                                 char                                 nchar                                char                                 text                                 nchar                                nchar
cidr                                 □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               cidr                                 none                                 □□□□□□                               □□□□□□
circle                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               circle                               none                                 □□□□□□                               □□□□□□
date                                 date                                 date                                 date                                 date                                 datetime                             date                                 date                                 date                                 none                                 date                                 date
dbclob                               clob                                 dbclob                               clob                                 clob                                 memo                                 text                                 clob                                 text                                 text                                 text                                 text
dbclob(n)                            clob                                 dbclob(n)                            clob(n)                              clob(n)                              memo                                 text                                 clob                                 text                                 text                                 text                                 text
double precision(m,d)                □□□□□□                               decimal(p,s)                         decimal(p,s)                         decimal(p,s)                         double                               double(m,d)                          number(p,s)                          decimal(p,s)                         real                                 decimal(p,s)                         decimal(p,s)
enum                                 □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               text                                 enum                                 □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□
decfloat16                           float                                decfloat(16)                         float                                float                                double                               float                                float                                float                                real                                 float                                float
float(p)                             float(p)                             decfloat(p)                          float(p)                             float(p)                             double                               float(p)                             float(p)                             float(p)                             real                                 float(p)                             float(p)
float(m,d)                           □□□□□□                               decimal(p,s)                         decimal(p,s)                         decimal(p,s)                         double                               float(m,d)                           number(p,s)                          decimal(p,s)                         real                                 decimal(p,s)                         decimal(p,s)
geometry                             □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□
hierarchyid                          □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               none                                 hierarchyid                          hierarchyid
image                                blob                                 blob                                 blob                                 blob                                 longbinary                           blob                                 blob                                 bytea                                none                                 image                                image
inet                                 □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               inet                                 none                                 □□□□□□                               □□□□□□
int(n)                               int                                  int                                  int                                  int                                  long                                 int(n)                               number(10,0)                         int                                  integer                              int                                  int
interval                             □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval                             □□□□□□                               □□□□□□                               □□□□□□
interval(p)                          □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval(p)                          □□□□□□                               □□□□□□                               □□□□□□
interval year                        □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval year                        □□□□□□                               □□□□□□                               □□□□□□
interval month                       □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval month                       □□□□□□                               □□□□□□                               □□□□□□
interval day                         □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval day                         □□□□□□                               □□□□□□                               □□□□□□
interval hour                        □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval hour                        □□□□□□                               □□□□□□                               □□□□□□
interval minute                      □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval minute                      □□□□□□                               □□□□□□                               □□□□□□
interval second                      □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval second                      □□□□□□                               □□□□□□                               □□□□□□
interval second(p)                   □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval second(p)                   □□□□□□                               □□□□□□                               □□□□□□
interval year to month               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval year to month               interval year to month               □□□□□□                               □□□□□□                               □□□□□□
interval year(p) to month            □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval year(p) to month            interval year to month               □□□□□□                               □□□□□□                               □□□□□□
interval day to hour                 □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval day to hour                 □□□□□□                               □□□□□□                               □□□□□□
interval day to minute               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval day to minute               □□□□□□                               □□□□□□                               □□□□□□
interval day to second               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval day to second               interval day to second               □□□□□□                               □□□□□□                               □□□□□□
interval day to second(p)            □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval day to second(p)            interval day to second(p)            □□□□□□                               □□□□□□                               □□□□□□
interval day(p) to second            □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval day(p) to second            interval day to second(p)            □□□□□□                               □□□□□□                               □□□□□□
interval day(p) to second(p)         □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval day(p) to second(p)         interval day to second(p)            □□□□□□                               □□□□□□                               □□□□□□
interval hour to minute              □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval hour to minute              □□□□□□                               □□□□□□                               □□□□□□
interval hour to second              □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval hour to second              □□□□□□                               □□□□□□                               □□□□□□
interval hour to second(p)           □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval hour to second(p)           □□□□□□                               □□□□□□                               □□□□□□
interval minute to second            □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval minute to second            □□□□□□                               □□□□□□                               □□□□□□
interval minute to second(p)         □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               interval minute to second(p)         □□□□□□                               □□□□□□                               □□□□□□
line                                 □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               line                                 none                                 □□□□□□                               □□□□□□
long                                 blob                                 blob                                 blob                                 blob                                 longbinary                           blob                                 long                                 bytea                                none                                 varbinary(max)                       varbinary(max)
longblob                             blob                                 blob                                 blob                                 blob                                 longbinary                           longblob                             blob                                 bytea                                none                                 varbinary(max)                       varbinary(max)
long raw                             blob                                 blob                                 blob                                 blob                                 longbinary                           longblob                             long raw                             bytea                                none                                 varbinary(max)                       varbinary(max)
longtext                             clob                                 clob                                 clob                                 clob                                 memo                                 longtext                             clob                                 text                                 text                                 text                                 text
longvarchar                          clob                                 clob                                 longvarchar                          longvarchar                          memo                                 text                                 clob                                 text                                 text                                 text                                 text
longvarbinary                        blob                                 blob                                 longvarbinary                        longvarbinary                        longbinary                           blob                                 blob                                 bytea                                none                                 varbinary(max)                       varbinary(max)
lseg                                 □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               lseg                                 none                                 □□□□□□                               □□□□□□
macaddr                              □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               macaddr                              none                                 □□□□□□                               □□□□□□
mediumblob                           blob                                 blob                                 blob                                 blob                                 longbinary                           mediumblob                           blob                                 bytea                                none                                 varbinary(max)                       varbinary(max)
mediumint                            int                                  int                                  int                                  int                                  long                                 mediumint                            number(7,0)                          int                                  integer                              int                                  int
mediumint(n)                         int                                  int                                  int                                  int                                  long                                 mediumint(n)                         number(7,0)                          int                                  integer                              int                                  int
mediumtext                           text                                 clob                                 clob                                 clob                                 text                                 mediumtext                           clob                                 text                                 text                                 text                                 text
money                                money                                decimal(19,4)                        decimal(19,4)                        decimal(19,4)                        currency                             decimal(19,4)                        number(19,4)                         money                                numeric                              money                                money
smallmoney                           smallmoney                           decimal(10,4)                        decimal(10,4)                        decimal(10,4)                        currency                             decimal(10,4)                        number(10,4)                         money                                numeric                              smallmoney                           smallmoney
oid                                  □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               oid                                  □□□□□□                               □□□□□□                               □□□□□□
other                                □□□□□□                               □□□□□□                               other                                other                                □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               none                                 □□□□□□                               □□□□□□
path                                 □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               path                                 none                                 □□□□□□                               □□□□□□
point                                □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               point                                none                                 □□□□□□                               □□□□□□
polygon                              □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               polygon                              none                                 □□□□□□                               □□□□□□
raw(n)                               varbinary(n)                         varchar(n) for bit data              varbinary                            varbinary                            longbinary                           varbinary(n)                         raw(n)                               bytea                                none                                 varbinary(n)                         varbinary(n)
real(m,d)                            real(m,d)                            decimal(p,s)                         decimal(p,s)                         decimal(p,s)                         float                                real(m,d)                            number(p,s)                          decimal(p,s)                         real                                 decimal(p,s)                         decimal(p,s)
rowguidcol                           □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□
rowversion                           □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               none                                 rowversion                           rowversion
serial                               int                                  int                                  int                                  int                                  counter                              int                                  number(10,0)                         serial                               integer                              int                                  int
set                                  □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               set                                  □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□
smallint(n)                          smallint                             smallint                             smallint                             smallint                             smallint                             smallint(n)                          number(5,0)                          smallint                             integer                              smallint                             smallint
time                                 time                                 time                                 time                                 time                                 datetime                             time                                 date                                 time                                 none                                 time                                 time
time(p)                              time(p)                              time                                 time                                 time                                 datetime                             time                                 date                                 time(p)                              none                                 time(p)                              time(p)
time with time zone                  time with time zone                  time                                 time                                 time                                 datetime                             time                                 timestamp with time zone             time with time zone                  none                                 time                                 time
time(p) with time zone               time(p) with time zone               time                                 time                                 time                                 datetime                             time                                 timestamp(p) with time zone          time(p) with time zone               none                                 time(p)                              time(p)
timestamp                            timestamp                            timestamp                            timestamp                            timestamp                            datetime                             timestamp                            timestamp                            timestamp                            none                                 datetime                             datetime
datetime2                            □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□
timestamp(p)                         timestamp(p)                         timestamp                            timestamp(p)                         timestamp(p)                         datetime                             timestamp                            timestamp(p)                         timestamp(p)                         none                                 datetime2(p)                         datetime2(p)
timestamp with time zone             timestamp with time zone             timestamp                            timestamp                            timestamp                            datetime                             timestamp                            timestamp with time zone             timestamp with time zone             none                                 datetimeoffset                       datetimeoffset
timestamp(p) with time zone          timestamp(p) with time zone          timestamp                            timestamp(p)                         timestamp(p)                         datetime                             timestamp                            timestamp(p) with time zone          timestamp(p) with time zone          none                                 datetimeoffset                       datetimeoffset
timestamp with local time zone       timestamp with local time zone       timestamp                            timestamp                            timestamp                            datetime                             timestamp                            timestamp with local time zone       timestamp with time zone             none                                 datetimeoffset                       datetimeoffset
timestamp(p) with local time zone    timestamp(p) with local time zone    timestamp                            timestamp(p)                         timestamp(p)                         datetime                             timestamp                            timestamp(p) with local time zone    timestamp(p) with time zone          none                                 datetimeoffset                       datetimeoffset
datetime                             datetime                             timestamp                            datetime                             datetime                             datetime                             datetime                             timestamp                            timestamp                            none                                 datetime                             datetime
smalldatetime                        smalldatetime                        timestamp                            timestamp                            timestamp                            datetime                             timestamp                            timestamp                            timestamp                            none                                 smalldatetime                        smalldatetime
tinyblob                             blob                                 blob                                 blob                                 blob                                 longbinary                           tinyblob                             blob                                 bytea                                none                                 varbinary(max)                       varbinary(max)
tinyint                              tinyint                              smallint                             tinyint                              tinyint                              byte                                 tinyint                              number(3,0)                          smallint                             integer                              tinyint                              tinyint
tinyint(n)                           tinyint                              smallint                             tinyint                              tinyint                              byte                                 tinyint(n)                           number(3,0)                          smallint                             integer                              tinyint                              tinyint
tinytext                             text                                 clob                                 varchar                              varchar                              text                                 tinytext                             clob                                 text                                 text                                 text                                 text
urowid                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               urowid                               □□□□□□                               none                                 □□□□□□                               □□□□□□
urowid(n)                            □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               urowid(n)                            □□□□□□                               none                                 □□□□□□                               □□□□□□
uuid                                 □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               guid                                 □□□□□□                               rowid                                uuid                                 none                                 uniqueidentifier                     uniqueidentifier
xml                                  xml                                  xml                                  □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               xmltype                              xml                                  □□□□□□                               xml                                  xml
year(2)                              int                                  int                                  int                                  int                                  smallint                             year(2)                              number(2,0)                          int                                  integer                              int                                  int
year(4)                              int                                  int                                  int                                  int                                  smallint                             year(4)                              number(4,0)                          int                                  integer                              int                                  int
alert_type                           □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               alert_type                           □□□□□□                               none                                 □□□□□□                               □□□□□□
anydata                              □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               □□□□□□                               anydata                              □□□□□□                               none                                 □□□□□□                               □□□□□□

-- for StandardSQL
CREATE TABLE TYPE_TEST (
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xnchar(1),
    COL_Xnvarchar(1),
    COL_Xdecimal,
    COL_Xdecimal(1),
    COL_Xdecimal(1,1),
    COL_Xnumeric,
    COL_Xnumeric(1),
    COL_Xnumeric(1,1),
    COL_Xinteger,
    COL_Xsmallint,
    COL_Xfloat,
    COL_Xdouble,
    COL_Xreal,
    COL_Xtext,
    COL_Xclob,
    COL_Xclob(1),
    COL_Xnclob,
    COL_Xntext,
    COL_Xvarchar,
    COL_Xvarchar,
    COL_Xvarchar(1),
    COL_Xnvarchar,
    COL_Xblob,
    COL_Xblob(1),
    COL_Xblob,
    COL_Xvarbinary,
    COL_Xvarbinary(1),
    COL_Xbigint,
    COL_Xbigint,
    COL_Xbigint,
    COL_Xdouble,
    COL_Xfloat,
    COL_Xbinary(1),
    COL_Xbinary,
    COL_Xbit,
    COL_Xbit(1),
    COL_Xvarying,
    COL_Xvarying(1),
    COL_Xboolean,
    COL_Xchar,
    COL_Xnchar,
    COL_Xdate,
    COL_Xclob,
    COL_Xclob,
    COL_Xfloat,
    COL_Xfloat(1),
    COL_Xblob,
    COL_Xint,
    COL_Xblob,
    COL_Xblob,
    COL_Xblob,
    COL_Xclob,
    COL_Xclob,
    COL_Xblob,
    COL_Xblob,
    COL_Xint,
    COL_Xint,
    COL_Xtext,
    COL_Xmoney,
    COL_Xsmallmoney,
    COL_Xvarbinary(1),
    COL_Xreal(1,1),
    COL_Xint,
    COL_Xsmallint,
    COL_Xtime,
    COL_Xtime(1),
    COL_Xzone,
    COL_Xzone,
    COL_Xtimestamp,
    COL_Xtimestamp(1),
    COL_Xzone,
    COL_Xzone,
    COL_Xzone,
    COL_Xzone,
    COL_Xdatetime,
    COL_Xsmalldatetime,
    COL_Xblob,
    COL_Xtinyint,
    COL_Xtinyint,
    COL_Xtext,
    COL_Xxml,
    COL_Xint,
    COL_Xint
);

-- for DB2
CREATE TABLE TYPE_TEST (
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xgraphic(1),
    COL_Xvargraphic(1),
    COL_Xdecimal,
    COL_Xdecimal(1),
    COL_Xdecimal(1,1),
    COL_Xnumeric,
    COL_Xnumeric(1),
    COL_Xnumeric(1,1),
    COL_Xint,
    COL_Xsmallint,
    COL_Xdecfloat,
    COL_Xdouble,
    COL_Xreal,
    COL_Xclob,
    COL_Xclob,
    COL_Xclob(1),
    COL_Xclob,
    COL_Xclob,
    COL_Xvarchar(1),
    COL_Xvarchar(1),
    COL_Xvarchar(1),
    COL_Xvargraphic(1),
    COL_Xblob,
    COL_Xblob(1),
    COL_Xblob,
    COL_Xdata,
    COL_Xdata,
    COL_Xbigint,
    COL_Xbigint,
    COL_Xbigint,
    COL_Xdouble,
    COL_Xdecfloat,
    COL_Xdata,
    COL_Xdata,
    COL_Xchar(1),
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xvarchar(1),
    COL_Xchar(1),
    COL_Xchar,
    COL_Xgraphic,
    COL_Xdate,
    COL_Xdbclob,
    COL_Xdbclob(1),
    COL_Xdecimal(1,1),
    COL_Xdecfloat(16),
    COL_Xdecfloat(1),
    COL_Xdecimal(1,1),
    COL_Xblob,
    COL_Xint,
    COL_Xblob,
    COL_Xblob,
    COL_Xblob,
    COL_Xclob,
    COL_Xclob,
    COL_Xblob,
    COL_Xblob,
    COL_Xint,
    COL_Xint,
    COL_Xclob,
    COL_Xdecimal(19,4),
    COL_Xdecimal(10,4),
    COL_Xdata,
    COL_Xdecimal(1,1),
    COL_Xint,
    COL_Xsmallint,
    COL_Xtime,
    COL_Xtime,
    COL_Xtime,
    COL_Xtime,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xblob,
    COL_Xsmallint,
    COL_Xsmallint,
    COL_Xclob,
    COL_Xxml,
    COL_Xint,
    COL_Xint
);

-- for H2
CREATE TABLE TYPE_TEST (
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xdecimal,
    COL_Xdecimal(1),
    COL_Xdecimal(1,1),
    COL_Xnumeric,
    COL_Xnumeric(1),
    COL_Xnumeric(1,1),
    COL_Xint,
    COL_Xsmallint,
    COL_Xfloat,
    COL_Xdouble,
    COL_Xreal,
    COL_Xclob,
    COL_Xclob,
    COL_Xclob(1),
    COL_Xclob,
    COL_Xclob,
    COL_Xvarchar,
    COL_Xvarchar_ignorecase,
    COL_Xvarchar_ignorecase(1),
    COL_Xvarchar,
    COL_Xblob,
    COL_Xblob(1),
    COL_Xblob,
    COL_Xvarbinary,
    COL_Xvarbinary(1),
    COL_Xbigint,
    COL_Xbigint,
    COL_Xbigint,
    COL_Xdouble,
    COL_Xfloat,
    COL_Xbinary,
    COL_Xbinary,
    COL_Xbit,
    COL_Xchar(1),
    COL_Xvarchar,
    COL_Xvarchar(1),
    COL_Xboolean,
    COL_Xchar,
    COL_Xchar,
    COL_Xdate,
    COL_Xclob,
    COL_Xclob(1),
    COL_Xdecimal(1,1),
    COL_Xfloat,
    COL_Xfloat(1),
    COL_Xdecimal(1,1),
    COL_Xblob,
    COL_Xint,
    COL_Xblob,
    COL_Xblob,
    COL_Xblob,
    COL_Xclob,
    COL_Xlongvarchar,
    COL_Xlongvarbinary,
    COL_Xblob,
    COL_Xint,
    COL_Xint,
    COL_Xclob,
    COL_Xdecimal(19,4),
    COL_Xdecimal(10,4),
    COL_Xother,
    COL_Xvarbinary,
    COL_Xdecimal(1,1),
    COL_Xint,
    COL_Xsmallint,
    COL_Xtime,
    COL_Xtime,
    COL_Xtime,
    COL_Xtime,
    COL_Xtimestamp,
    COL_Xtimestamp(1),
    COL_Xtimestamp,
    COL_Xtimestamp(1),
    COL_Xtimestamp,
    COL_Xtimestamp(1),
    COL_Xdatetime,
    COL_Xtimestamp,
    COL_Xblob,
    COL_Xtinyint,
    COL_Xtinyint,
    COL_Xvarchar,
    COL_Xint,
    COL_Xint
);

-- for HSQLDB
CREATE TABLE TYPE_TEST (
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xdecimal,
    COL_Xdecimal(1),
    COL_Xdecimal(1,1),
    COL_Xnumeric,
    COL_Xnumeric(1),
    COL_Xnumeric(1,1),
    COL_Xint,
    COL_Xsmallint,
    COL_Xfloat,
    COL_Xdouble,
    COL_Xreal,
    COL_Xclob,
    COL_Xclob,
    COL_Xclob(1),
    COL_Xclob,
    COL_Xclob,
    COL_Xvarchar,
    COL_Xvarchar_ignorecase,
    COL_Xvarchar_ignorecase(1),
    COL_Xvarchar,
    COL_Xblob,
    COL_Xblob(1),
    COL_Xblob,
    COL_Xvarbinary,
    COL_Xvarbinary(1),
    COL_Xbigint,
    COL_Xbigint,
    COL_Xbigint,
    COL_Xdouble,
    COL_Xfloat,
    COL_Xbinary,
    COL_Xbinary,
    COL_Xbit,
    COL_Xchar(1),
    COL_Xvarchar,
    COL_Xvarchar(1),
    COL_Xboolean,
    COL_Xchar,
    COL_Xchar,
    COL_Xdate,
    COL_Xclob,
    COL_Xclob(1),
    COL_Xdecimal(1,1),
    COL_Xfloat,
    COL_Xfloat(1),
    COL_Xdecimal(1,1),
    COL_Xblob,
    COL_Xint,
    COL_Xblob,
    COL_Xblob,
    COL_Xblob,
    COL_Xclob,
    COL_Xlongvarchar,
    COL_Xlongvarbinary,
    COL_Xblob,
    COL_Xint,
    COL_Xint,
    COL_Xclob,
    COL_Xdecimal(19,4),
    COL_Xdecimal(10,4),
    COL_Xother,
    COL_Xvarbinary,
    COL_Xdecimal(1,1),
    COL_Xint,
    COL_Xsmallint,
    COL_Xtime,
    COL_Xtime,
    COL_Xtime,
    COL_Xtime,
    COL_Xtimestamp,
    COL_Xtimestamp(1),
    COL_Xtimestamp,
    COL_Xtimestamp(1),
    COL_Xtimestamp,
    COL_Xtimestamp(1),
    COL_Xdatetime,
    COL_Xtimestamp,
    COL_Xblob,
    COL_Xtinyint,
    COL_Xtinyint,
    COL_Xvarchar,
    COL_Xint,
    COL_Xint
);

-- for MSAccess
CREATE TABLE TYPE_TEST (
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xdecimal,
    COL_Xdecimal,
    COL_Xdecimal,
    COL_Xdecimal,
    COL_Xdecimal,
    COL_Xdecimal,
    COL_Xlong,
    COL_Xsmallint,
    COL_Xdouble,
    COL_Xdouble,
    COL_Xreal,
    COL_Xtext,
    COL_Xmemo,
    COL_Xmemo,
    COL_Xmemo,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xlongbinary,
    COL_Xlongbinary,
    COL_Xlongbinary,
    COL_Xlongbinary,
    COL_Xlongbinary,
    COL_Xlong,
    COL_Xlong,
    COL_Xcounter,
    COL_Xdouble,
    COL_Xdouble,
    COL_Xlongbinary,
    COL_Xlongbinary,
    COL_Xyesno,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xyesno,
    COL_Xtext,
    COL_Xtext,
    COL_Xdatetime,
    COL_Xmemo,
    COL_Xmemo,
    COL_Xdouble,
    COL_Xtext('1'),
    COL_Xdouble,
    COL_Xdouble,
    COL_Xdouble,
    COL_Xlongbinary,
    COL_Xlong,
    COL_Xlongbinary,
    COL_Xlongbinary,
    COL_Xlongbinary,
    COL_Xmemo,
    COL_Xmemo,
    COL_Xlongbinary,
    COL_Xlongbinary,
    COL_Xlong,
    COL_Xlong,
    COL_Xtext,
    COL_Xcurrency,
    COL_Xcurrency,
    COL_Xlongbinary,
    COL_Xfloat,
    COL_Xcounter,
    COL_Xsmallint,
    COL_Xdatetime,
    COL_Xdatetime,
    COL_Xdatetime,
    COL_Xdatetime,
    COL_Xdatetime,
    COL_Xdatetime,
    COL_Xdatetime,
    COL_Xdatetime,
    COL_Xdatetime,
    COL_Xdatetime,
    COL_Xdatetime,
    COL_Xdatetime,
    COL_Xlongbinary,
    COL_Xbyte,
    COL_Xbyte,
    COL_Xtext,
    COL_Xguid,
    COL_Xsmallint,
    COL_Xsmallint
);

-- for MySQL
CREATE TABLE TYPE_TEST (
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xdecimal,
    COL_Xdecimal(1),
    COL_Xdecimal(1,1),
    COL_Xnumeric,
    COL_Xnumeric(1),
    COL_Xnumeric(1,1),
    COL_Xint,
    COL_Xsmallint,
    COL_Xfloat,
    COL_Xdouble,
    COL_Xreal,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xvarchar(1),
    COL_Xvarchar(1),
    COL_Xvarchar(1),
    COL_Xvarchar(1),
    COL_Xblob,
    COL_Xblob,
    COL_Xblob,
    COL_Xvarbinary(1),
    COL_Xvarbinary(1),
    COL_Xbigint,
    COL_Xbigint(1),
    COL_Xbigint,
    COL_Xdouble,
    COL_Xfloat,
    COL_Xbinary(1),
    COL_Xbinary,
    COL_Xbit(1),
    COL_Xbit(1),
    COL_Xtext,
    COL_Xvarchar(1),
    COL_Xboolean,
    COL_Xchar,
    COL_Xchar,
    COL_Xdate,
    COL_Xtext,
    COL_Xtext,
    COL_Xdouble(1,1),
    COL_Xenum('1'),
    COL_Xfloat,
    COL_Xfloat(1),
    COL_Xfloat(1,1),
    COL_Xblob,
    COL_Xint(1),
    COL_Xblob,
    COL_Xlongblob,
    COL_Xlongblob,
    COL_Xlongtext,
    COL_Xtext,
    COL_Xblob,
    COL_Xmediumblob,
    COL_Xmediumint,
    COL_Xmediumint(1),
    COL_Xmediumtext,
    COL_Xdecimal(19,4),
    COL_Xdecimal(10,4),
    COL_Xvarbinary(1),
    COL_Xreal(1,1),
    COL_Xint,
    COL_Xset('1'),
    COL_Xsmallint(1),
    COL_Xtime,
    COL_Xtime,
    COL_Xtime,
    COL_Xtime,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xdatetime,
    COL_Xtimestamp,
    COL_Xtinyblob,
    COL_Xtinyint,
    COL_Xtinyint(1),
    COL_Xtinytext,
    COL_Xyear(2),
    COL_Xyear(4)
);

-- for Oracle
CREATE TABLE TYPE_TEST (
    COL_Xchar(1),
    COL_Xvarchar2(1),
    COL_Xnchar(1),
    COL_Xnvarchar2(1),
    COL_Xnumber,
    COL_Xnumber(1),
    COL_Xnumber(1,1),
    COL_Xnumber,
    COL_Xnumber(1),
    COL_Xnumber(1,1),
    COL_Xnumber(10,0),
    COL_Xnumber(5,0),
    COL_Xfloat,
    COL_Xfloat(24),
    COL_Xfloat(24),
    COL_Xclob,
    COL_Xclob,
    COL_Xclob,
    COL_Xnclob,
    COL_Xnclob,
    COL_Xvarchar2(1),
    COL_Xvarchar2(1),
    COL_Xvarchar2(1),
    COL_Xnvarchar2(1),
    COL_Xblob,
    COL_Xblob,
    COL_Xbfile,
    COL_Xblob,
    COL_Xblob,
    COL_Xnumber(19,0),
    COL_Xnumber(19,0),
    COL_Xnumber(19,0),
    COL_Xbinary_double,
    COL_Xbinary_float,
    COL_Xraw(1),
    COL_Xraw(1),
    COL_Xchar(1),
    COL_Xchar(1),
    COL_Xvarchar2(1),
    COL_Xvarchar2(1),
    COL_Xchar(1),
    COL_Xchar,
    COL_Xnchar,
    COL_Xdate,
    COL_Xclob,
    COL_Xclob,
    COL_Xnumber(1,1),
    COL_Xfloat,
    COL_Xfloat(1),
    COL_Xnumber(1,1),
    COL_Xblob,
    COL_Xnumber(10,0),
    COL_Xmonth,
    COL_Xmonth,
    COL_Xsecond,
    COL_Xsecond(1),
    COL_Xsecond,
    COL_Xsecond(1),
    COL_Xlong,
    COL_Xblob,
    COL_Xraw,
    COL_Xclob,
    COL_Xclob,
    COL_Xblob,
    COL_Xblob,
    COL_Xnumber(7,0),
    COL_Xnumber(7,0),
    COL_Xclob,
    COL_Xnumber(19,4),
    COL_Xnumber(10,4),
    COL_Xraw(1),
    COL_Xnumber(1,1),
    COL_Xnumber(10,0),
    COL_Xnumber(5,0),
    COL_Xdate,
    COL_Xdate,
    COL_Xzone,
    COL_Xzone,
    COL_Xtimestamp,
    COL_Xtimestamp(1),
    COL_Xzone,
    COL_Xzone,
    COL_Xzone,
    COL_Xzone,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xblob,
    COL_Xnumber(3,0),
    COL_Xnumber(3,0),
    COL_Xclob,
    COL_Xurowid,
    COL_Xurowid(1),
    COL_Xrowid,
    COL_Xxmltype,
    COL_Xnumber(2,0),
    COL_Xnumber(4,0),
    COL_Xalert_type,
    COL_Xanydata
);

-- for PostgreSQL
CREATE TABLE TYPE_TEST (
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xdecimal,
    COL_Xdecimal(1),
    COL_Xdecimal(1,1),
    COL_Xnumeric,
    COL_Xnumeric(1),
    COL_Xnumeric(1,1),
    COL_Xint,
    COL_Xsmallint,
    COL_Xfloat,
    COL_Xprecision,
    COL_Xreal,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xvarchar,
    COL_Xvarchar,
    COL_Xvarchar(1),
    COL_Xvarchar,
    COL_Xbytea,
    COL_Xbytea,
    COL_Xbytea,
    COL_Xbytea,
    COL_Xbytea,
    COL_Xbigint,
    COL_Xbigint,
    COL_Xbigserial,
    COL_Xprecision,
    COL_Xfloat,
    COL_Xbytea,
    COL_Xbytea,
    COL_Xbit,
    COL_Xbit(1),
    COL_Xvarying,
    COL_Xvarying(1),
    COL_Xboolean,
    COL_Xbox,
    COL_Xchar,
    COL_Xchar,
    COL_Xcidr,
    COL_Xcircle,
    COL_Xdate,
    COL_Xtext,
    COL_Xtext,
    COL_Xdecimal(1,1),
    COL_Xfloat,
    COL_Xfloat(1),
    COL_Xdecimal(1,1),
    COL_Xbytea,
    COL_Xinet,
    COL_Xint,
    COL_Xinterval,
    COL_Xinterval(1),
    COL_Xyear,
    COL_Xmonth,
    COL_Xday,
    COL_Xhour,
    COL_Xminute,
    COL_Xsecond,
    COL_Xsecond(1),
    COL_Xmonth,
    COL_Xmonth,
    COL_Xhour,
    COL_Xminute,
    COL_Xsecond,
    COL_Xsecond(1),
    COL_Xsecond(1),
    COL_Xsecond(1),
    COL_Xminute,
    COL_Xsecond,
    COL_Xsecond(1),
    COL_Xsecond,
    COL_Xsecond(1),
    COL_Xline,
    COL_Xbytea,
    COL_Xbytea,
    COL_Xbytea,
    COL_Xtext,
    COL_Xtext,
    COL_Xbytea,
    COL_Xlseg,
    COL_Xmacaddr,
    COL_Xbytea,
    COL_Xint,
    COL_Xint,
    COL_Xtext,
    COL_Xmoney,
    COL_Xmoney,
    COL_Xoid,
    COL_Xpath,
    COL_Xpoint,
    COL_Xpolygon,
    COL_Xbytea,
    COL_Xdecimal(1,1),
    COL_Xserial,
    COL_Xsmallint,
    COL_Xtime,
    COL_Xtime(1),
    COL_Xzone,
    COL_Xzone,
    COL_Xtimestamp,
    COL_Xtimestamp(1),
    COL_Xzone,
    COL_Xzone,
    COL_Xzone,
    COL_Xzone,
    COL_Xtimestamp,
    COL_Xtimestamp,
    COL_Xbytea,
    COL_Xsmallint,
    COL_Xsmallint,
    COL_Xtext,
    COL_Xuuid,
    COL_Xxml,
    COL_Xint,
    COL_Xint
);

-- for SQLite
CREATE TABLE TYPE_TEST (
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xnumeric,
    COL_Xnumeric,
    COL_Xnumeric,
    COL_Xnumeric,
    COL_Xnumeric,
    COL_Xnumeric,
    COL_Xinteger,
    COL_Xinteger,
    COL_Xreal,
    COL_Xreal,
    COL_Xreal,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xinteger,
    COL_Xinteger,
    COL_Xinteger,
    COL_Xreal,
    COL_Xreal,
    COL_Xnone,
    COL_Xnone,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xnone,
    COL_Xtext,
    COL_Xtext,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xtext,
    COL_Xtext,
    COL_Xreal,
    COL_Xreal,
    COL_Xreal,
    COL_Xreal,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xinteger,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xtext,
    COL_Xtext,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xinteger,
    COL_Xinteger,
    COL_Xtext,
    COL_Xnumeric,
    COL_Xnumeric,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xreal,
    COL_Xnone,
    COL_Xinteger,
    COL_Xinteger,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xinteger,
    COL_Xinteger,
    COL_Xtext,
    COL_Xnone,
    COL_Xnone,
    COL_Xnone,
    COL_Xinteger,
    COL_Xinteger,
    COL_Xnone,
    COL_Xnone
);

-- for SQLServer
CREATE TABLE TYPE_TEST (
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xnchar(1),
    COL_Xnvarchar(1),
    COL_Xdecimal,
    COL_Xdecimal(1),
    COL_Xdecimal(1,1),
    COL_Xnumeric,
    COL_Xnumeric(1),
    COL_Xnumeric(1,1),
    COL_Xint,
    COL_Xsmallint,
    COL_Xfloat,
    COL_Xfloat(53),
    COL_Xreal,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xntext,
    COL_Xntext,
    COL_Xvarchar(max),
    COL_Xvarchar(max),
    COL_Xvarchar(1),
    COL_Xnvarchar(max),
    COL_Xvarbinary(max),
    COL_Xvarbinary(1),
    COL_Xvarbinary(max),
    COL_Xvarbinary(max),
    COL_Xvarbinary(1),
    COL_Xbigint,
    COL_Xbigint,
    COL_Xbigint,
    COL_Xfloat(53),
    COL_Xfloat,
    COL_Xbinary(1),
    COL_Xbinary,
    COL_Xbit,
    COL_Xchar(1),
    COL_Xvarchar(max),
    COL_Xvarchar(1),
    COL_Xbit,
    COL_Xchar,
    COL_Xnchar,
    COL_Xdate,
    COL_Xtext,
    COL_Xtext,
    COL_Xdecimal(1,1),
    COL_Xfloat,
    COL_Xfloat(1),
    COL_Xdecimal(1,1),
    COL_Xhierarchyid,
    COL_Ximage,
    COL_Xint,
    COL_Xvarbinary(max),
    COL_Xvarbinary(max),
    COL_Xvarbinary(max),
    COL_Xtext,
    COL_Xtext,
    COL_Xvarbinary(max),
    COL_Xvarbinary(max),
    COL_Xint,
    COL_Xint,
    COL_Xtext,
    COL_Xmoney,
    COL_Xsmallmoney,
    COL_Xvarbinary(1),
    COL_Xdecimal(1,1),
    COL_Xrowversion,
    COL_Xint,
    COL_Xsmallint,
    COL_Xtime,
    COL_Xtime(1),
    COL_Xtime,
    COL_Xtime(1),
    COL_Xdatetime,
    COL_Xdatetime2(1),
    COL_Xdatetimeoffset,
    COL_Xdatetimeoffset,
    COL_Xdatetimeoffset,
    COL_Xdatetimeoffset,
    COL_Xdatetime,
    COL_Xsmalldatetime,
    COL_Xvarbinary(max),
    COL_Xtinyint,
    COL_Xtinyint,
    COL_Xtext,
    COL_X,
    COL_Xxml,
    COL_Xint,
    COL_Xint
);

-- for SQLServer 2008
CREATE TABLE TYPE_TEST (
    COL_Xchar(1),
    COL_Xvarchar(1),
    COL_Xnchar(1),
    COL_Xnvarchar(1),
    COL_Xdecimal,
    COL_Xdecimal(1),
    COL_Xdecimal(1,1),
    COL_Xnumeric,
    COL_Xnumeric(1),
    COL_Xnumeric(1,1),
    COL_Xint,
    COL_Xsmallint,
    COL_Xfloat,
    COL_Xfloat(53),
    COL_Xreal,
    COL_Xtext,
    COL_Xtext,
    COL_Xtext,
    COL_Xntext,
    COL_Xntext,
    COL_Xvarchar(max),
    COL_Xvarchar(max),
    COL_Xvarchar(1),
    COL_Xnvarchar(max),
    COL_Xvarbinary(max),
    COL_Xvarbinary(1),
    COL_Xvarbinary(max),
    COL_Xvarbinary(max),
    COL_Xvarbinary(1),
    COL_Xbigint,
    COL_Xbigint,
    COL_Xbigint,
    COL_Xfloat(53),
    COL_Xfloat,
    COL_Xbinary(1),
    COL_Xbinary,
    COL_Xbit,
    COL_Xchar(1),
    COL_Xvarchar(max),
    COL_Xvarchar(1),
    COL_Xbit,
    COL_Xchar,
    COL_Xnchar,
    COL_Xdate,
    COL_Xtext,
    COL_Xtext,
    COL_Xdecimal(1,1),
    COL_Xfloat,
    COL_Xfloat(1),
    COL_Xdecimal(1,1),
    COL_Xhierarchyid,
    COL_Ximage,
    COL_Xint,
    COL_Xvarbinary(max),
    COL_Xvarbinary(max),
    COL_Xvarbinary(max),
    COL_Xtext,
    COL_Xtext,
    COL_Xvarbinary(max),
    COL_Xvarbinary(max),
    COL_Xint,
    COL_Xint,
    COL_Xtext,
    COL_Xmoney,
    COL_Xsmallmoney,
    COL_Xvarbinary(1),
    COL_Xdecimal(1,1),
    COL_Xrowversion,
    COL_Xint,
    COL_Xsmallint,
    COL_Xtime,
    COL_Xtime(1),
    COL_Xtime,
    COL_Xtime(1),
    COL_Xdatetime,
    COL_Xdatetime2(1),
    COL_Xdatetimeoffset,
    COL_Xdatetimeoffset,
    COL_Xdatetimeoffset,
    COL_Xdatetimeoffset,
    COL_Xdatetime,
    COL_Xsmalldatetime,
    COL_Xvarbinary(max),
    COL_Xtinyint,
    COL_Xtinyint,
    COL_Xtext,
    COL_X,
    COL_Xxml,
    COL_Xint,
    COL_Xint
);


0 個の型が変換できませんでした。
0 個の数字型の指定が不足しています。
0 個の数字型の指定が余分です。
