DB2 Data types vs OLDB Data types
|
DB2 TYPE_NAME |
OLEDB DATA_TYPE |
|
SMALLINT |
DBTYPE_I2 |
|
INTEGER |
DBTYPE_I4 |
|
REAL |
DBTYPE_R4 |
|
FLOAT |
DBTYPE_R8 |
|
DOUBLE |
DBTYPE_R8 |
|
DECIMAL |
DBTYPE_DECIMAL |
|
GRAPHIC |
DBTYPE_STR |
|
VARGRAPHIC |
DBTYPE_STR |
|
CHAR |
DBTYPE_STR |
|
VARCHAR |
DBTYPE_STR |
|
CHAR () FOR BIT DATA |
DBTYPE_BYTES |
|
VARCHAR () FOR BIT DATA |
DBTYPE_BYTES |
|
NUMERIC |
DBTYPE_NUMERIC |
|
DATE |
DBTYPE_DBDATE |
|
TIME |
DBTYPE_DBTIME |
|
TIMESTAMP |
DBTYPE_DBTIMESTAMP |
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
Comments
