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/06 21:20] els |
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 | | + | |
- | | DATE | 10-byte ANSI date | | + | |
- | | TIME | 11-byte ANSI time | | + | |
- | | 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}} |