This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:appendix:reference:datatypes [2010/07/23 04:50] els old revision restored |
dev:appendix:reference:datatypes [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ====== Appendix ====== | ====== Appendix ====== | ||
| - | [[dev:appendix:home|Appendix]] -> [[dev:appendix:reference:home|Reference]] -> **[[dev:appendix:reference:datatypes|Omnidex Datatypes]]** | + | [[dev:appendix:home|Appendix]] | [[dev:appendix:reference:home|Reference]] | **[[dev:appendix:reference:datatypes|Omnidex Datatypes]]** |
| ===== Omnidex Datatypes ===== | ===== Omnidex Datatypes ===== | ||
| Line 13: | Line 13: | ||
| Omnidex supports the following standard datatypes: | Omnidex supports the following standard datatypes: | ||
| - | ^ Datatype ^ Description ^ | + | {{page>dev:appendix:reference:datatypes_insert&nofooter&noeditbtn}} |
| - | | CHARACTER(//n//) | Space-filled character string of //n// characters | | + | |
| - | | CHAR(//n//) | Synonym for CHARACTER(//n//) | | + | |
| - | | C 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 C STRING datatypes rather than VARCHAR and CLOB due to the requirement of a length variable. || | + | |
| ==== National Character Datatypes ==== | ==== National Character Datatypes ==== | ||
| Line 52: | Line 22: | ||
| datatypes. | datatypes. | ||
| - | ^ Datatype ^ Description ^ | + | {{page>dev:appendix:reference:natl_datatypes_insert&nofooter&noeditbtn}} |
| - | | NATIONAL CHARACTER(//n//) | Space-filled character string of //n// characters | | + | |
| - | | NATIONAL CHAR(//n//) | Synonym for CHARACTER(//n//) | | + | |
| - | | NATIONAL C 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 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}} | ||