Appendix: Reference

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.

Additional Resources

See also:

 
Back to top
appendix/reference/datatypes.txt ยท Last modified: 2018/09/24 19:03 by doc