This is an old revision of the document!
Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example
Omnidex supports most MySQL datatypes; however, care must be taken when mapping the MySQL datatypes to Omnidex.
Most MySQL binary data is stored in the internal NUMBER datatype. This datatype cannot be returned to applications, and so applications must choose an appropriate external datatype for presentation. Omnidex allows NUMBER datatypes to be returned as BIGINT, INTEGER, SMALLINT, TINYINT, FLOAT or DOUBLE. Note that if the EXTRACT statement is used to generate CREATE TABLE statements, Omnidex will consider the declared scale and precision and guess at an appropriate matching binary datatype; however, administrators should review and validate these assignments. If scale and precision are not specified, Omnidex will necessarily use a DOUBLE datatype. For the best performance and ease of development, these datatypes should be changed to the smallest binary datatype that will accommodate the values in the column.
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 datatpes, but recommends the use of CHARACTER datatype. |
| NATIONAL VARCHAR | NATIONAL VARCHAR | Omnidex has limited support for Unicode datatpes, 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 |
See also: