This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
appendix:reference:datatypes [2011/03/15 20:07] els created |
appendix:reference:datatypes [2018/09/24 19:03] (current) doc |
||
---|---|---|---|
Line 29: | Line 29: | ||
| FLOAT | IEEE four-byte, single-precision floating point | | | FLOAT | IEEE four-byte, single-precision floating point | | ||
| DOUBLE | IEEE eight-byte, double-precision floating point | | | DOUBLE | IEEE eight-byte, double-precision floating point | | ||
- | | DATE | 10-byte ANSI date | | + | | ANSI DATE | 10-byte ANSI date | |
- | | TIME | 11-byte ANSI time | | + | | ANSI TIME | 11-byte ANSI time | |
- | | DATETIME | 24-byte ANSI datetime | | + | | ANSI DATETIME | 24-byte ANSI datetime | |
| ASCII DATE | 8-byte ASCII date ( YYYYMMDD ) | | | ASCII DATE | 8-byte ASCII date ( YYYYMMDD ) | | ||
| ASCII DATE(6) | 6-byte ASCII date ( YYMMDD ) | | | ASCII DATE(6) | 6-byte ASCII date ( YYMMDD ) | | ||
Line 59: | Line 59: | ||
| NATIONAL CLOB(//n//)* | Character large object 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. || | | * 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. | ||
+ | |||
+ | * **[[integration:rdbms:oracle:datatypes|Oracle Integration Guide]]** | ||
+ | * **[[integration:rdbms:sqlserver:datatypes|SQL Server Integration Guide]]** | ||
+ | * **[[integration:rdbms:mysql:datatypes|MySQL Integration Guide]]** | ||
+ | * **[[integration:rdbms:odbc:datatypes|Generic ODBC Integration Guide]]** | ||