From OPeNDAP Documentation
⧼opendap2-jumptonavigation⧽
Introduction
Previous Design/Implementation
Data model representation
Atomic (Simple) Types
Table Test 1
Transact-SQL (Microsoft)
| Type |
Range |
Storage Bytes |
DAP equiv.
|
| bigint |
|
8 bytes |
none
|
| int |
|
4 bytes |
|
| numeric |
|
|
|
| decimal |
|
|
|
| bit |
|
|
|
| smallint |
|
2 bytes |
|
| tinyint |
|
1 bytes |
|
| smallmoney |
|
|
|
| money |
|
|
|
| float |
|
4 or 8 bytes |
|
| real |
|
4 bytes |
|
| date |
|
|
|
| datetimeoffset |
|
|
|
| datetime2 |
|
|
|
| smalldatetime |
|
|
|
| datetime |
|
|
|
| time |
|
|
|
| char |
|
|
|
| varchar |
|
|
|
| next |
|
|
|
| nchar |
|
|
|
| nvarchar |
|
|
|
| ntext |
|
|
|
| binary |
|
|
|
| varbinary |
|
|
|
| image |
|
|
|
| cursor |
|
|
|
| timestamp |
|
|
|
| hierarchyid |
|
|
|
| uniquieidentifier |
|
|
|
| sql_variant |
|
|
|
| xml |
|
|
|
| table |
|
|
|
PostgreSQL Data Types
Boolean and Binary Types
| Data Type |
Description |
Standardization |
Logical DAP data type association.
|
| boolean, bool |
A single true or false value. |
SQL99 |
Boolean
|
| bit(n) |
An n -length bit string (exactly n binary bits). |
SQL92 |
None
|
| bit varying(n), varbit(n) |
A variable n -length bit string (up to n binary bits) |
SQL92 |
None
|
Desired Features
Implementation Target
