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 |
|
|
|
Table test 2
PostgreSQL Data Types (from Practical PostgreSQL)
| Catagory |
Data Type |
Description |
Standardization |
Logical DAP data type association.
|
| Boolean and binary types
|
| boolean, bool
|
| bit(n)
|
| bit varying(n), varbit(n)
|
|
| A single true or false value.
|
| An n -length bit string (exactly n binary bits).
|
| A variable n -length bit string (up to n binary bits)
|
|
|
|
Desired Features
Implementation Target
