Home | Categories | Alphabetical | Classes | All Contents | [ < ] | [ > ]

Data Type Mappings


SQL data types have been mapped to IDL DataMiner data types so that you can access and manipulate the data without having to fully understand SQL. Table 2-2 details these mappings.

IDL Type
SQL Type
STRING
DECIMAL
NUMERIC
CHAR
LONG VARCHAR
BYTE
BIT
TINYINT
BIGINT
INT
SMALLINT
LONG
INTEGER
LONG64
BIGINT
FLOAT
REAL
DOUBLE
FLOAT
DOUBLE PRECISION
BYTE ARRAY
BINARY
VARBINARY
VARCHAR
LONG VARBINARY
ODBC_SQL_DATE Struct
DATE
ODBC_SQL_TIME Struct
TIME
ODBC_SQL_TIMESTAMP Struct
TIMESTAMP


Home | Categories | Alphabetical | Classes | All Contents | [ < ] | [ > ]