Moderator
Moderator

Question

How is a ODBC data type mapped to EXASOL data type?

How is a EXASOL data type mapped to ODBC data type?

Answer

ODBC to EXASOL:

ODBC data type -> EXASOL data type
     
SQL_BIGINT   DECIMAL(36,0)
SQL_BINARY    
SQL_CHAR   CHAR
SQL_DECIMAL(p,s)   DECIMAL(p,s)
SQL_DOUBLE   DOUBLE PRECISION
SQL_FLOAT   DOUBLE PRECISION
SQL_INTEGER   DECIMAL(18,0)
SQL_INTERVAL_YEAR    
SQL_INTERVAL_MONTH    
SQL_INTERVAL_YEAR_TO_MONTH   VARCHAR( n )
SQL_INTERVAL_DAY    
SQL_INTERVAL_HOUR    
SQL_INTERVAL_MINUTE    
SQL_INTERVAL_SECOND    
SQL_INTERVAL_DAY_TO_HOUR    
SQL_INTERVAL_DAY_TO_MINUTE    
SQL_INTERVAL_DAY_TO_SECOND   VARCHAR( n )
SQL_INTERVAL_HOUR_TO_MINUTE    
SQL_INTERVAL_HOUR_TO_SECOND    
SQL_INTERVAL_MINUTE_TO_SECOND    
SQL_LONGVARBINARY    
SQL_LONGVARCHAR   VARCHAR( n )
SQL_NUMERIC(p[,s])   DECIMAL( p,s )
SQL_REAL   DOUBLE PRECISION
SQL_SMALLINT   DECIMAL(9,0)
SQL_TYPE_TIME    
SQL_TINYINT   DECIMAL(3,0)
SQL_TYPE_DATE   DATE
SQL_TIMESTAMP   TIMESTAMP
SQL_VARBINARY    
SQL_VARCHAR   VARCHAR( n )
SQL_WCHAR   VARCHAR( n )
SQL_WVARCHAR   VARCHAR( n )
SQL_WLONGVARCHAR   VARCHAR( n )
SQL_BIT   BOOLEAN

EXASOL to ODBC:

EXASOL data type -> ODBC data type
DECIMAL( p,s )   SQL_DECIMAL( p,s )
CHAR( n )   SQL_CHAR( n )
VARCHAR( n )   SQL_VARCHAR( n )
DOUBLE PRECISION   SQL_DOUBLE
BOOLEAN   SQL_BIT
DATE   SQL_TYPE_DATE
TIMESTAMP   SQL_TYPE_TIMESTAMP
TIMESTAMP WITH LOCAL TIME ZONE   SQL_TYPE_TIMESTAMP
INVERVAL YEAR TO MONTH   SQL_CHAR( n )
INTERVAL DAY TO SECOND   SQL_CHAR( n )
GEOMETRY   SQL_VARCHAR(2000000)
HASHTYPE ( * )   SQL_VARCHAR

( * ) Exasol Version 7.0.0