MySQL 5.5 Adapter Limitations

Supported Version

This adapter supports types as follows.

Type name	Support	Remarks
BOOL (BOOLEAN)	Yes	Alias of tinyint(1)
BIT	Limited
TINYINT	Yes
TINYINT UNSIGNED	Yes
MEDIUMINT	Yes
MEDIUMINT UNSIGNED	Yes
SMALLINT	Yes
SMALLINT UNSIGNED	Yes
INT (INTEGER)	Yes
INT UNSIGNED (INTEGER UNSIGNED)	Yes
BIGINT	Yes
BIGINT UNSIGNED	Yes
FLOAT	Limited
FLOAT UNSIGNED	Limited
DOUBLE	Limited
DOUBLE UNSIGNED	Limited
REAL	Limited
REAL UNSIGNED	Limited
DECIMAL (NUMERIC)	Yes
DECIMAL UNSIGNED (NUMERIC UNSIGNED)	Yes
DATE	Limited
DATETIME	Limited
TIMESTAMP	Limited
TIME	Limited
YEAR	Limited
CHAR	Limited
VARCHAR	Limited
BINARY	Yes
VARBINARY	Yes
TINYBLOB	Yes
TINYTEXT	Limited
BLOB	Yes
TEXT	Limited
MEDIUMBLOB	Yes
MEDIUMTEXT	Limited
LONGBLOB	Yes
LONGTEXT	Limited
ENUM	Limited
SET	Limited

BIT
- BIT type data that size is 1 is treated as Boolean.Other sized BIT type is not supported.
FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below). http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
DOUBLE, DOUBLE UNSIGNED
- For more information refer to "MySQL Reference Manual" (the URL below).
  For more information refer to "MySQL Reference Manual" (the URL below). http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
DATE, DATETIME, TIMESTAMP
- Error occurs when data is 0000-00-00 00:00:00.
TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.
YEAR
- Treated as String data.
Even if a table name is enclosed by quotation marks, table names are not case sensitive.

Even if ZEROFILL optional extension attribute is specified, it returns results in which 0s are excluded.

BIT
- BIT type data that size is 1 is treated as Boolean.Other sized BIT type is not supported.
FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below). http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below). http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
DATE, DATETIME, TIMESTAMP
- Error occurs when data is 0000-00-00 00:00:00.
TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.
YEAR
- Treated as String data.
Even if a table name is enclosed by quotation marks, table names are not case sensitive.

Even if ZEROFILL optional extension attribute is specified, it returns results in which 0s are excluded.

BIT
- BIT type data that size is 1 is treated as Boolean.Other sized BIT type is not supported.
FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below). http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below). http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
DATE, DATETIME, TIMESTAMP
- If the date does not exist, it will not be written correctly.
  For example: "00 month 00 day, 0000" becomes "November 30, 0002".
TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.
YEAR
- Treated as String data.
Even if a table name is enclosed by quotation marks, table names are not case sensitive.

BIT
- BIT type data that size is 1 is treated as Boolean.Other sized BIT type is not supported.
FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below). http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below). http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
DATE, DATETIME, TIMESTAMP
- If the date does not exist, it will not be written correctly.
  For example: "00 month 00 day, 0000" becomes "November 30, 0002".
TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.
YEAR
- Treated as String data.
Even if a table name is enclosed by quotation marks, table names are not case sensitive.

BIT
- BIT type data that size is 1 is treated as Boolean.Other sized BIT type is not supported.
FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below). http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below). http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
CHAR, VARCHAR, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT
- When using the argument that contains a multi-byte character, an error occurs.
TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.
YEAR
- Treated as String data.
ENUM, SET
- When using the argument that contains a multi-byte character, an error occurs.
Even if a table name is enclosed by quotation marks, table names are not case sensitive.

Exception name	Cause	Actions
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException	Cannot connect to the database.	Check the [Hostname] and [Port number].
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException Unknown database '<database name>'	The database does not exist.	Make sure the specified [Database name] exists.
java.sql.SQLException Access denied for user '<username >'@'< terminal name>' (using password: YES)	Connected to the database but cannot login.	Check that the correct [User name] and [Password] is specified.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException Table '<table name>' doesn't exist	The table does not exist.	Make sure the specified [Table name] exists.