This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
dev:appendix:reference:datatypes [2010/07/23 04:48] els |
dev:appendix:reference:datatypes [2010/07/27 05:27] els |
||
|---|---|---|---|
| Line 13: | Line 13: | ||
| Omnidex supports the following standard datatypes: | Omnidex supports the following standard datatypes: | ||
| - | ^ Datatype ^ Description ^ | + | ^Datatype ^Class ^Description ^ |
| - | | CHARACTER(//n//) | Space-filled character string of //n// characters | | + | |CHARACTER(//n//) |STRING |Space-filled character string of //n// characters | |
| - | | CHAR(//n//) | Synonym for CHARACTER(//n//) | | + | |CHAR(//n//) |STRING |Synonym for CHARACTER(//n//) | |
| - | | C STRING(//n//) | Null-terminated character string of //n// characters | | + | |C STRING(//n//) |STRING |Null-terminated character string of //n// characters | |
| - | | VARCHAR(//n//)* | String of max //n// characters, with length variable | | + | |VARCHAR(//n//)* |STRING |String of max //n// characters, with length variable | |
| - | | CLOB(//n//)* | Character large object of max //n// characters, with length variable | | + | |CLOB(//n//)* |STRING |Character large object of max //n// characters, with length variable | |
| - | | [SIGNED] TINYINT | 1-byte, signed integer ( -128 to 127 ) | | + | |[SIGNED] TINYINT |NUMERIC |1-byte, signed integer ( -128 to 127 ) | |
| - | | UNSIGNED TINYINT | 1-byte, unsigned integer ( 0 to 255 ) | | + | |UNSIGNED TINYINT |NUMERIC |1-byte, unsigned integer ( 0 to 255 ) | |
| - | | [SIGNED] SMALLINT | 2-byte, signed integer ( -32768 to 32767 ) | | + | |[SIGNED] SMALLINT |NUMERIC |2-byte, signed integer ( -32768 to 32767 ) | |
| - | | UNSIGNED SMALLINT | 2-byte, unsigned integer ( 0 to 65535 ) | | + | |UNSIGNED SMALLINT |NUMERIC |2-byte, unsigned integer ( 0 to 65535 ) | |
| - | | [SIGNED] INTEGER | 4-byte, signed integer ( 2147483648 to 2147483647 ) | | + | |[SIGNED] INTEGER |NUMERIC |4-byte, signed integer ( 2147483648 to 2147483647 ) | |
| - | | UNSIGNED INTEGER | 4-byte, unsigned integer ( 0 to 4294967295 ) | | + | |UNSIGNED INTEGER |NUMERIC |4-byte, unsigned integer ( 0 to 4294967295 ) | |
| - | | [SIGNED] BIGINT | 8-byte, signed integer ( %%-2^63 to 2^63-1%% ) | | + | |[SIGNED] BIGINT |NUMERIC |8-byte, signed integer ( %%-2^63 to 2^63-1%% ) | |
| - | | UNSIGNED BIGINT | 8-byte, unsigned integer ( %%0 to 2^64-1%% ) | | + | |UNSIGNED BIGINT |NUMERIC |8-byte, unsigned integer ( %%0 to 2^64-1%% ) | |
| - | | FLOAT | IEEE four-byte, single-precision floating point | | + | |FLOAT |NUMERIC |IEEE four-byte, single-precision floating point | |
| - | | DOUBLE | IEEE eight-byte, double-precision floating point | | + | |DOUBLE |NUMERIC |IEEE eight-byte, double-precision floating point | |
| - | | ASCII DATE | 8-byte ASCII date ( YYYYMMDD ) | | + | |ANSI DATE |DATE |10-byte ANSI date | |
| - | | ASCII DATE(6) | 6-byte ASCII date ( YYMMDD ) | | + | |ANSI TIME |DATE |11-byte ANSI time | |
| - | | ODBC DATE | 6-byte ODBC proprietary date | | + | |ANSI DATETIME |DATE |24-byte ANSI datetime | |
| - | | ODBC TIME | 6-byte ODBC proprietary time | | + | |ASCII DATE |DATE |8-byte ASCII date ( YYYYMMDD ) | |
| - | | ODBC DATETIME | 6-byte ODBC proprietary datetime | | + | |ASCII DATE(6) |DATE |6-byte ASCII date ( YYMMDD ) | |
| - | | ORACLE DATE | 7-byte Oracle proprietary date | | + | |C DATETIME |DATE |8-byte integer based on the C time() routine | |
| - | | ORACLE TIME | 7-byte Oracle proprietary time | | + | |ODBC DATE |DATE |6-byte ODBC proprietary date | |
| - | | ORACLE DATETIME | 7-byte Oracle proprietary datetime | | + | |ODBC TIME |DATE |6-byte ODBC proprietary time | |
| - | | OMNIDEX DATE(//n//) | Omnidex proprietary date supporting //n// digits of YYYYMMDD | | + | |ODBC DATETIME |DATE |6-byte ODBC proprietary datetime | |
| - | | OMNIDEX TIME(//n//) | Omnidex proprietary time supporting //n// digits of HHMMSSNN | | + | |ORACLE DATE |DATE |7-byte Oracle proprietary date | |
| - | | OMNIDEX DATETIME(//n//) | Omnidex proprietary datetime supporting //n// digits of YYYYMMDDHHMMSSNN | | + | |ORACLE TIME |DATE |7-byte Oracle proprietary time | |
| - | | * Omnidex recommends use of the CHARACTER and C STRING datatypes rather than VARCHAR and CLOB due to the requirement of a length variable. || | + | |ORACLE DATETIME |DATE |7-byte Oracle proprietary datetime | |
| + | |OMNIDEX DATE(//n//) |DATE |Omnidex proprietary date supporting //n// digits of YYYYMMDD | | ||
| + | |OMNIDEX TIME(//n//) |DATE |Omnidex proprietary time supporting //n// digits of HHMMSSNN | | ||
| + | |OMNIDEX DATETIME(//n//)|DATE |Omnidex proprietary datetime supporting //n// digits of YYYYMMDDHHMMSSNN | | ||
| + | |* Omnidex recommends use of the CHARACTER and C STRING datatypes rather than VARCHAR and CLOB due to the requirement of a length variable. ||| | ||
| ==== National Character Datatypes ==== | ==== National Character Datatypes ==== | ||
| Line 49: | Line 53: | ||
| datatypes. | datatypes. | ||
| - | ^ Datatype ^ Description ^ | + | ^Datatype ^Class ^Description ^ |
| - | | NATIONAL CHARACTER(//n//) | Space-filled character string of //n// characters | | + | |NATIONAL CHARACTER(//n//) |STRING |Space-filled character string of //n// characters | |
| - | | NATIONAL CHAR(//n//) | Synonym for CHARACTER(//n//) | | + | |NATIONAL CHAR(//n//) |STRING |Synonym for CHARACTER(//n//) | |
| - | | NATIONAL C STRING(//n//) | Null-terminated character string of //n// characters | | + | |NATIONAL C STRING(//n//) |STRING |Null-terminated character string of //n// characters | |
| - | | NATIONAL VARCHAR(//n//)* | String of max //n// characters, with length variable | | + | |NATIONAL VARCHAR(//n//)* |STRING |String of max //n// characters, with length variable | |
| - | | NATIONAL CLOB(//n//)* | Character large object of max //n// characters, with length variable | | + | |NATIONAL CLOB(//n//)* |STRING |Character large object of max //n// characters, with length variable | |
| - | | * Omnidex recommends use of the NATIONAL CHARACTER and NATIONAL C STRING datatypes rather than NATIONAL VARCHAR and NATIONAL CLOB due to the requirement of a length variable. || | + | | * Omnidex recommends use of the NATIONAL CHARACTER and NATIONAL C STRING datatypes rather than NATIONAL VARCHAR and NATIONAL CLOB due to the requirement of a length variable. ||| |
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||