Reference

Support Types of Database

Oracle

1. String Types
   CHAR, NCHAR, VARCHAR, NVARCHAR, VARCHAR2, NVARCHAR2

2. Numeric Types
   SMALLINT, INTEGER, INT, REAL, FLOAT, BINARY_FLOAT, DOUBLE, BINARY_DOUBLE, NUMBER

3. Date and Time Types
   DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE

4. LOB (Large Object) Types
   CLOB, BLOB, BFILE, LONG, RAW, NCLOB, LONG RAW

5. Others
   ROWID, UROWID, URITYPE, SYS.URITYPE

IBM DB2

1. String Types
   CHAR, VARCHAR, GRAPHIC, VARGRAPHIC

2. Numeric Types
   SMALLINT, INTEGER, BIGINT, FLOAT, REAL, DOUBLE, DECIMAL, NUMERIC

3. Date and Time Types
   TIME, DATE, TIMESTAMP

4. LOB (Large Object) Types
   LONG VARCHAR, LONG VARGRAPHIC, CLOB, BLOB, DBCLOB

Sybase

1. String Types
   CHAR, VARCHAR, UNICHAR, UNIVARCHAR, NCHAR, NVARCHAR

2. Numeric Types
   TINYINT, SMALLINT, INT, BIGINT, UNSIGNED BIGINT, UNSIGNED INT, UNSIGNED SMALLINT, INTEGER, FLOAT, DOUBLE PRECISION, DECIMAL, REAL, SMALLMONEY, MONEY, NUMERIC

3. Date and Time Types
   TIME, DATE, SMALLDATE, SMALLDATETIME, DATETIME, BIGDATETIME, BIGTIME

4. LOB (Large Object) Types
   TEXT, UNITEXT, VARBINARY, IMAGE

5. Others
   BIT

Microsoft SQL Server

1. String Types
   CHAR, VARCHAR, NCHAR, NVARCHAR

2. Numeric Types
   TINYINT, SMALLINT, INT, BIGINT, INTEGER, DECIMAL, NUMERIC, FLOAT, REAL, SMALLMONEY, MONEY

3. Date and Time Types
   TIME, DATE, SMALLDATETIME, DATETIME, DATETIME2, DATETIMEOFFSET

4. LOB (Large Object) Types
   IMAGE, BINARY, TEXT, NTEXT, VARBINARY

5. Others
   BIT, UNIQUEIDENTIFIER, TIMESTAMP

MySQL

1. String Types
   CHAR, CHARACTER, NATIONAL CHAR, SET, EMNU, VARCHAR, NVARCHAR

2. Numeric Types
   TINYINT, TINYINT UNSIGNED, SMALLINT, SMALLINT UNSIGNED, MEDIUMINT, MEDIUMINT UNSIGNED, INTEGER, INT, INTEGER UNSIGNED, INT UNSIGNED, BIGINT, BIGINT UNSIGNED, SERIAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, NUMERIC UNSIGNED, FIXED, FIXED UNSIGNED, DEC, DEC UNSIGNED, FLOAT UNSIGNED, DOUBLE UNSIGNED, DECIMAL UNSIGNED

3. Date and Time Types
   TIME, DATE, DATETIME, TIMESTAMP, YEAR

4. LOB (Large Object) Types
   TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB

5. Others
   BIT, BINARY, VARBINARY

Programming DEMO

//TODO