Integration: Relational Databases

MySQL

Datatypes

Omnidex supports most MySQL datatypes; however, care must be taken when mapping the MySQL datatypes to Omnidex. Omnidex accesses MySQL using the MySQL ODBC Connector, and so the datatype correlations will follow the ODBC standard.

Omnidex has very limited support for Unicode datatypes, also known as National Character datatypes. Omnidex can retrieve and return these datatypes, but cannot index beyond the standard ASCII character set. The MySQL NATIONAL datatypes should be declared as STRING or CHARACTER datatypes within Omnidex.

Omnidex does not support many of the MySQL LOB datatypes, though MySQL CLOB datatypes can be mapped to an Omnidex STRING or CLOB datatype. Omnidex does not support binary large objects.

The following table correlates the MySQL and Omnidex datatypes:

MySQL Datatype Omnidex Datatype Comments
CHAR CHAR(ACTER)
VARCHAR STRING or VARCHAR Favor STRING unless your character data cannot be terminated by a NULL character.
NATIONAL CHAR NATIONAL CHAR(ACTER) Omnidex has limited support for Unicode datatypes, but recommends the use of CHARACTER datatype.
NATIONAL VARCHAR NATIONAL VARCHAR Omnidex has limited support for Unicode datatypes, but recommends the use of STRING datatype.
BIT TINYINT
TINYINT TINYINT
BOOLEAN TINYINT
SMALLINT SMALLINT
MEDIUMINT INTEGER
INTEGER INTEGER
BIGINT BIGINT
FLOAT FLOAT
DOUBLE DOUBLE
DECIMAL DOUBLE, CHAR(ACTER)
DATE ODBC DATE
DATETIME ODBC DATETIME
TIMESTAMP ODBC DATETIME
TIME ODBC TIME
YEAR SMALLINT
TINYTEXT STRING or CLOB Favor STRING unless your character data cannot be terminated by a NULL character.
TEXT STRING or CLOB Favor STRING unless your character data cannot be terminated by a NULL character.
MEDIUMTEXT STRING or CLOB Favor STRING unless your character data cannot be terminated by a NULL character.
LONGTEXT STRING or CLOB Favor STRING unless your character data cannot be terminated by a NULL character.
ENUM STRING
SET STRING
BINARY Unsupported
VARBINARY Unsupported
TINYBLOB Unsupported
BLOB Unsupported
MEDIUMBLOB Unsupported
LONGBLOB Unsupported

Additional Resources

See also:

 
Back to top
integration/rdbms/mysql/datatypes.txt ยท Last modified: 2016/06/28 22:38 (external edit)