skip to main content
DataDirect Connect Drivers : MySQL Driver : Data Types
  
Data Types
The following table lists the data types supported by the MySQL driver and describes how they are mapped to JDBC data types.
Table 39. MySQL Data Types
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
DECIMAL UNSIGNED
DECIMAL
DOUBLE
DOUBLE
DOUBLE UNSIGNED
DOUBLE
FLOAT
REAL
FLOAT UNSIGNED
REAL
INTEGER
INTEGER
INTEGER UNSIGNED
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
Refer to "getTypeInfo()" in the DataDirect Connect Series for JDBC Reference for more information about data types.