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 |
Exception name | Causes | Solution | |
---|---|---|---|
com.mysql.jdbc.exceptions.jdbc4.CommunicationsExceptionn | Cannot connect to database. | Make sure that [Hostname] or [Port number] in Global Resource is correct. | |
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException | Unknown database '<database name>' | The specified database does not exists. | Make sure that the database specified in the [Database name] in Global Resource exists. |
java.sql.SQLException | Access denied for user '<user name>'@'<terminal name>'(using password: YES) | Username or password is invalid. | Make sure both [User name] and [Password] specified in Global Resource are valid. |
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException | Table '<table name>' does not exist | The table specified does not exists. | Specify a table name which exists in [Table name]. |