MySQL

The following MySQL data types are supported by DataDirect Database dirvers:

MySQL Data Type JDBC Data Type
BIGINT BIGINT
BIGINT UNSIGNED BIGINT
BINARY BINARY
BIT BINARY
BLOB LONGVARBINARY
CHAR(n) CHAR
DATE DATE
DATETIME TIMESTAMP
DECIMAL DECIMAL
DOUBLE DOUBLE
FLOAT REAL
INTEGER INTEGER
LONGBLOB LONGVARBINARY
LONGTEXT LONGVARCHAR
MEDIUMBLOB LONGVARBINARY
MEDIUMINT INTEGER
MEDIUMINT UNSIGNED INTEGER
MEDIUMTEXT LONGVARCHAR
SMALLINT SMALLINT
SMALLINT UNSIGNED SMALLINT
TEXT LONGVARCHAR
TIME TIME
TIMESTAMP TIMESTAMP
TINYBLOB LONGVARBINARY
TINYINT TINYINT
TINYINT UNSIGNED TINYINT
TINYTEXT LONGVARCHAR
VARBINARY VARBINARY
VARCHAR(n) VARCHAR
YEAR SMALLINT

Limitations of Using MySQL Database Types

Note: When you use the MySQL database, note the following conditions:
  • When you run Subscription Service with the MySQL database connected, Subscription Service does not support the YEAR data type. To resolve this issue, add the yearIsDateType=false property in the JDBC URL.
  • When you run Request-Response Service with the MySQL database connected and set DOUBLE as the data type, you have to change the DOUBLE data type to the STRING data type to avoid a boundary value error. You can set the connection option in the JDBC Properties tab in TIBCO Business Studio.