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