|
Supported Data Types - ODBC Driver for Snowflake |
|
|
|
Supported Data Types - ODBC Driver for Snowflake |
|
The Devart ODBC Driver for Snowflake supports all Snowflake data types.
The following table describes how the Snowflake data types are mapped to the ODBC data types.
| Snowflake Data Types | ODBC Data Types |
|---|---|
|
NUMBER NUMERIC |
SQL_NUMERIC |
|
DECIMAL |
SQL_DECIMAL |
|
TINYINT BYTEINT |
SQL_TINYINT |
|
SMALLINT |
SQL_SMALLINT |
|
INTEGER INTE |
SQL_INTEGER |
|
BIGINT |
SQL_BIT |
|
DOUBLE DOUBLE PRECISION |
SQL_DOUBLE |
|
FLOAT FLOAT4 FLOAT8 |
SQL_FLOAT |
|
REAL |
SQL_REAL |
|
CHAR, CHARACTER |
SQL_CHAR |
|
VARCHAR STRING TEXT |
Length <= 4000: SQL_VARCHAR Length > 4000: SQL_LONGVARCHAR |
|
VARBINARY BINARY |
Length <= 4000: SQL_VARBINARY Length > 4000: SQL_LONGVARBINARY |
|
BOOLEAN |
SQL_BIT |
|
DATE |
SQL_DATE |
|
TIME |
SQL_TIME |
|
DATETIME TIMESTAMP TIMESTAMP_NTZ TIMESTAMP_LTZ TIMESTAMP_TZ |
SQL_TIMESTAMP |
|
PICKLIST VARIANT OBJECT ARRAY GEOGRAPHY |
SQL_LONGVARCHAR |