The following chart shows how ODBC data types map to CA IDMS data types:
|
ODBC Data Type |
CA IDMS Data Type |
|---|---|
|
CAID_GRAPHIC - DBCS Enabled |
GRAPHIC |
|
CAID_VARGRAPHIC - DBCS Enabled |
VARGRAPHIC |
|
SQL_BINARY |
BINARY |
|
SQL_LONGVARBINARY |
BINARY |
|
SQL_CHAR |
CHAR |
|
SQL_TYPE_DATE |
DATE |
|
SQL_DECIMAL |
DECIMAL |
|
SQL_DOUBLE |
DOUBLE PRECISION |
|
SQL_FLOAT* |
DOUBLE PRECISION |
|
SQL_GUID |
CHAR |
|
SQL_REAL* |
REAL |
|
SQL_INTEGER |
INTEGER |
|
SQL_BIGINT |
LONGINT |
|
SQL_NUMERIC |
NUMERIC |
|
SQL_BIT |
SMALLINT |
|
SQL_SMALLINT |
SMALLINT |
|
SQL_TINYINT |
SMALLINT |
|
SQL_TYPE_TIME |
TIME |
|
SQL_TYPE_TIMESTAMP |
TIMESTAMP |
|
SQL_LONGVARCHAR |
VARCHAR |
|
SQL_VARCHAR |
VARCHAR |
|
All Interval Types |
CHAR |
Note: * Floating point conversion subject to rounding errors due to format differences.
|
Copyright © 2009 CA.
All rights reserved.
|
|