This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
integration:rdbms:odbc:datatypes [2011/04/06 17:43] 127.0.0.1 external edit |
integration:rdbms:odbc:datatypes [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 21: | Line 21: | ||
| ==== Datatypes ==== | ==== Datatypes ==== | ||
| - | Omnidex supports most ODBC datatypes; however, care must be taken when mapping the ODBC datatypes to Omnidex. Omnidex accesses ODBC using the ODBC ODBC Connector, and so the datatype correlations will follow the ODBC standard. | + | Omnidex supports most ODBC datatypes; however, care must be taken when mapping the ODBC datatypes to Omnidex. |
| - | 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 ODBC NATIONAL datatypes should be declared as STRING or CHARACTER datatypes within Omnidex. | + | Omnidex has very limited support for Unicode datatypes, also known as National Character datatypes or Wide Character Set datatypes. Omnidex can retrieve and return these datatypes, but cannot index beyond the standard ASCII character set. The SQL_W datatpyes should be declared as STRING or CHARACTER datatypes within Omnidex. |
| - | Omnidex does not support many of the ODBC LOB datatypes, though ODBC CLOB datatypes can be mapped to an Omnidex STRING or CLOB datatype. Omnidex does not support binary large objects. | + | Omnidex does not support binary large objects datatypes. |
| The following table correlates the ODBC and Omnidex datatypes: | The following table correlates the ODBC and Omnidex datatypes: | ||
| |< 100% 25% 25% 50% >| | |< 100% 25% 25% 50% >| | ||
| - | ^ ODBC Datatype ^ Omnidex Datatype ^ Comments ^ | + | ^ ODBC Datatype ^ Omnidex Datatype ^ Comments ^ |
| - | | CHAR | CHAR(ACTER) | | | + | | SQL_CHAR | CHAR(ACTER) | | |
| - | | VARCHAR | STRING or VARCHAR | Favor STRING unless your character data cannot be terminated by a NULL character. | | + | | SQL_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. | | + | | SQL_LONGVARCHAR | STRING or VARCHAR | Favor STRING unless your character data cannot be terminated by a NULL character. | |
| - | | NATIONAL VARCHAR | NATIONAL VARCHAR | Omnidex has limited support for Unicode datatpes, but recommends the use of STRING datatype. | | + | | SQL_WCHAR | NATIONAL CHAR(ACTER) | Omnidex has limited support for Unicode datatypes, but recommends the use of CHARACTER datatype. | |
| - | | BIT | TINYINT | | | + | | SQL_WVARCHAR | NATIONAL VARCHAR | Omnidex has limited support for Unicode datatypes, but recommends the use of STRING datatype. | |
| - | | TINYINT | TINYINT | | | + | | SQL_WLONGVARCHAR | NATIONAL VARCHAR | Omnidex has limited support for Unicode datatypes, but recommends the use of STRING datatype. | |
| - | | BOOLEAN | TINYINT | | | + | | SQL_DECIMAL | DOUBLE, CHAR(ACTER) | | |
| - | | SMALLINT | SMALLINT | | | + | | SQL_NUMERIC | DOUBLE, CHAR(ACTER) | | |
| - | | MEDIUMINT | INTEGER | | | + | | SQL_SMALLINT | SMALLINT | | |
| - | | INTEGER | INTEGER | | | + | | SQL_INTEGER | INTEGER | | |
| - | | BIGINT | BIGINT | | | + | | SQL_REAL | FLOAT | | |
| - | | FLOAT | FLOAT | | | + | | SQL_FLOAT | FLOAT | | |
| - | | DOUBLE | DOUBLE | | | + | | SQL_DOUBLE | DOUBLE | | |
| - | | DECIMAL | DOUBLE, CHAR(ACTER) | | | + | | SQL_BIT | TINYINT | | |
| - | | DATE | ODBC DATE | | | + | | SQL_TINYINT | TINYINT | | |
| - | | DATETIME | ODBC DATETIME | | | + | | SQL_BIGINT | BIGINT | | |
| - | | TIMESTAMP | ODBC DATETIME | | | + | | SQL_TYPE_DATE | ODBC DATE | | |
| - | | TIME | ODBC TIME | | | + | | SQL_TYPE_TIME | ODBC TIME | | |
| - | | YEAR | SMALLINT | | | + | | SQL_TYPE_TIMESTAMP | ODBC DATETIME | | |
| - | | TINYTEXT | STRING or CLOB | Favor STRING unless your character data cannot be terminated by a NULL character. | | + | | SQL_TYPE_UTCDATETIME | ODBC DATETIME | | |
| - | | TEXT | STRING or CLOB | Favor STRING unless your character data cannot be terminated by a NULL character. | | + | | SQL_TYPE_UTCTIME | ODBC TIME | | |
| - | | MEDIUMTEXT | STRING or CLOB | Favor STRING unless your character data cannot be terminated by a NULL character. | | + | | SQL_INTERVAL Datatypes | INTEGER | | |
| - | | LONGTEXT | STRING or CLOB | Favor STRING unless your character data cannot be terminated by a NULL character. | | + | | SQL_GUID | CHAR(ACTER) | | |
| - | | ENUM | STRING | | | + | | SQL_BINARY | Unsupported | | |
| - | | SET | STRING | | | + | | SQL_VARBINARY | Unsupported | | |
| - | | BINARY | Unsupported | | | + | | SQL_LONGVARBINARY | Unsupported | | |
| - | | VARBINARY | Unsupported | | | + | |
| - | | TINYBLOB | Unsupported | | | + | |
| - | | BLOB | Unsupported | | | + | |
| - | | MEDIUMBLOB | Unsupported | | | + | |
| - | | LONGBLOB | Unsupported | | | + | |