This shows you the differences between two versions of the page.
| — |
dev:sql:datatypes [2020/11/30 18:49] (current) doc created |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | {{page>:top_add&nofooter&noeditbtn}} | ||
| + | ===== Omnidex Datatypes ===== | ||
| + | ---- | ||
| + | |||
| + | |||
| + | ==== Standard Datatypes ==== | ||
| + | |||
| + | Omnidex supports the following standard datatypes: | ||
| + | |||
| + | ^ Datatype ^ Description ^ | ||
| + | | CHARACTER(//n//) | Space-filled character string of //n// characters | | ||
| + | | CHAR(//n//) | Synonym for CHARACTER(//n//) | | ||
| + | | STRING(//n//) | Null-terminated character string of //n// characters | | ||
| + | | VARCHAR(//n//)* | String of max //n// characters, with length variable | | ||
| + | | CLOB(//n//)* | Character large object of max //n// characters, with length variable | | ||
| + | | [SIGNED] TINYINT | 1-byte, signed integer ( -128 to 127 ) | | ||
| + | | UNSIGNED TINYINT | 1-byte, unsigned integer ( 0 to 255 ) | | ||
| + | | [SIGNED] SMALLINT | 2-byte, signed integer ( -32768 to 32767 ) | | ||
| + | | UNSIGNED SMALLINT | 2-byte, unsigned integer ( 0 to 65535 ) | | ||
| + | | [SIGNED] INTEGER | 4-byte, signed integer ( 2147483648 to 2147483647 ) | | ||
| + | | UNSIGNED INTEGER | 4-byte, unsigned integer ( 0 to 4294967295 ) | | ||
| + | | [SIGNED] BIGINT | 8-byte, signed integer ( %%-2^63 to 2^63-1%% ) | | ||
| + | | UNSIGNED BIGINT | 8-byte, unsigned integer ( %%0 to 2^64-1%% ) | | ||
| + | | FLOAT | IEEE four-byte, single-precision floating point | | ||
| + | | DOUBLE | IEEE eight-byte, double-precision floating point | | ||
| + | | ANSI DATE | 10-byte ANSI date | | ||
| + | | ANSI TIME | 11-byte ANSI time | | ||
| + | | ANSI DATETIME | 24-byte ANSI datetime | | ||
| + | | ASCII DATE | 8-byte ASCII date ( YYYYMMDD ) | | ||
| + | | ASCII DATE(6) | 6-byte ASCII date ( YYMMDD ) | | ||
| + | | ODBC DATE | 6-byte ODBC proprietary date | | ||
| + | | ODBC TIME | 6-byte ODBC proprietary time | | ||
| + | | ODBC DATETIME | 6-byte ODBC proprietary datetime | | ||
| + | | ORACLE DATE | 7-byte Oracle proprietary date | | ||
| + | | ORACLE TIME | 7-byte Oracle proprietary time | | ||
| + | | ORACLE DATETIME | 7-byte Oracle proprietary datetime | | ||
| + | | OMNIDEX DATE(//n//) | Omnidex proprietary date supporting //n// digits of YYYYMMDD | | ||
| + | | OMNIDEX TIME(//n//) | Omnidex proprietary time supporting //n// digits of HHMMSSNN | | ||
| + | | OMNIDEX DATETIME(//n//) | Omnidex proprietary datetime supporting //n// digits of YYYYMMDDHHMMSSNN | | ||
| + | | * Omnidex recommends use of the CHARACTER and STRING datatypes rather than VARCHAR and CLOB due to the requirement of a length variable. || | ||
| + | |||
| + | ==== National Character Datatypes ==== | ||
| + | |||
| + | Omnidex also provides partial support for National Character Datatypes (sometimes called | ||
| + | Unicode datatypes or wide characters). The Omnidex SQL Engine will process these | ||
| + | datatypes, but the Omnidex Indexing Engine will only index the lower 8 bits of these | ||
| + | datatypes. | ||
| + | |||
| + | ^ Datatype ^ Description ^ | ||
| + | | NATIONAL CHARACTER(//n//) | Space-filled character string of //n// characters | | ||
| + | | NATIONAL CHAR(//n//) | Synonym for CHARACTER(//n//) | | ||
| + | | NATIONAL STRING(//n//) | Null-terminated character string of //n// characters | | ||
| + | | NATIONAL VARCHAR(//n//)* | String of max //n// characters, with length variable | | ||
| + | | NATIONAL CLOB(//n//)* | Character large object of max //n// characters, with length variable | | ||
| + | | * Omnidex recommends use of the NATIONAL CHARACTER and NATIONAL STRING datatypes rather than NATIONAL VARCHAR and NATIONAL CLOB due to the requirement of a length variable. || | ||
| + | |||
| + | ==== Relational Database Datatypes ==== | ||
| + | |||
| + | Omnidex datatypes map to most of the underlying relational database datatypes. Consult the Omnidex Integration Guides for each of the relational databases to understand how these Omnidex datatypes map to the underlying relational database datatypes. | ||
| + | |||
| + | * **[[integration:rdbms:oracle:datatypes|Oracle Integration Guide]]** | ||
| + | * **[[integration:rdbms:sqlserver:datatypes|SQL Server Integration Guide]]** | ||
| + | * **[[integration:rdbms:mysql:datatypes|MySQL Integration Guide]]** | ||
| + | * **[[integration:rdbms:odbc:datatypes|Generic ODBC Integration Guide]]** | ||
| + | |||
| + | |||
| + | {{page>:bottom_add&nofooter&noeditbtn}} | ||