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/27 05:27] 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 ^Class ^Description ^ | + | {{page>dev:appendix:reference:datatypes_insert&nofooter&noeditbtn}} |
| - | |CHARACTER(//n//) |STRING |Space-filled character string of //n// characters | | + | |
| - | |CHAR(//n//) |STRING |Synonym for CHARACTER(//n//) | | + | |
| - | |C STRING(//n//) |STRING |Null-terminated character string of //n// characters | | + | |
| - | |VARCHAR(//n//)* |STRING |String of max //n// characters, with length variable | | + | |
| - | |CLOB(//n//)* |STRING |Character large object of max //n// characters, with length variable | | + | |
| - | |[SIGNED] TINYINT |NUMERIC |1-byte, signed integer ( -128 to 127 ) | | + | |
| - | |UNSIGNED TINYINT |NUMERIC |1-byte, unsigned integer ( 0 to 255 ) | | + | |
| - | |[SIGNED] SMALLINT |NUMERIC |2-byte, signed integer ( -32768 to 32767 ) | | + | |
| - | |UNSIGNED SMALLINT |NUMERIC |2-byte, unsigned integer ( 0 to 65535 ) | | + | |
| - | |[SIGNED] INTEGER |NUMERIC |4-byte, signed integer ( 2147483648 to 2147483647 ) | | + | |
| - | |UNSIGNED INTEGER |NUMERIC |4-byte, unsigned integer ( 0 to 4294967295 ) | | + | |
| - | |[SIGNED] BIGINT |NUMERIC |8-byte, signed integer ( %%-2^63 to 2^63-1%% ) | | + | |
| - | |UNSIGNED BIGINT |NUMERIC |8-byte, unsigned integer ( %%0 to 2^64-1%% ) | | + | |
| - | |FLOAT |NUMERIC |IEEE four-byte, single-precision floating point | | + | |
| - | |DOUBLE |NUMERIC |IEEE eight-byte, double-precision floating point | | + | |
| - | |ANSI DATE |DATE |10-byte ANSI date | | + | |
| - | |ANSI TIME |DATE |11-byte ANSI time | | + | |
| - | |ANSI DATETIME |DATE |24-byte ANSI datetime | | + | |
| - | |ASCII DATE |DATE |8-byte ASCII date ( YYYYMMDD ) | | + | |
| - | |ASCII DATE(6) |DATE |6-byte ASCII date ( YYMMDD ) | | + | |
| - | |C DATETIME |DATE |8-byte integer based on the C time() routine | | + | |
| - | |ODBC DATE |DATE |6-byte ODBC proprietary date | | + | |
| - | |ODBC TIME |DATE |6-byte ODBC proprietary time | | + | |
| - | |ODBC DATETIME |DATE |6-byte ODBC proprietary datetime | | + | |
| - | |ORACLE DATE |DATE |7-byte Oracle proprietary date | | + | |
| - | |ORACLE TIME |DATE |7-byte Oracle proprietary time | | + | |
| - | |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 53: | Line 22: | ||
| datatypes. | datatypes. | ||
| - | ^Datatype ^Class ^Description ^ | + | {{page>dev:appendix:reference:natl_datatypes_insert&nofooter&noeditbtn}} |
| - | |NATIONAL CHARACTER(//n//) |STRING |Space-filled character string of //n// characters | | + | |
| - | |NATIONAL CHAR(//n//) |STRING |Synonym for CHARACTER(//n//) | | + | |
| - | |NATIONAL C STRING(//n//) |STRING |Null-terminated character string of //n// characters | | + | |
| - | |NATIONAL VARCHAR(//n//)* |STRING |String 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. ||| | + | |
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||