This is an old revision of the document!
Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example
Omnidex supports most SQL Server datatypes; however, care must be taken when mapping the SQL Server datatypes to Omnidex. Omnidex accesses SQL Server using the SQL Server 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 SQL Server NATIONAL datatypes should be declared as STRING or CHARACTER datatypes within Omnidex.
Omnidex does not support many of the SQL Server LOB datatypes, though SQL Server CLOB datatypes can be mapped to an Omnidex STRING or CLOB datatype. Omnidex does not support binary large objects.
The following table correlates the SQL Server and Omnidex datatypes:
| SQL Server 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: