You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
[3] An application uses SQLGetTypeInfo or SQLColAttribute to determine whether a particular data type or a particular column in a result set is unsigned.
Table of types mapping (as above) - nice to see the reviewed table in docs.
The text was updated successfully, but these errors were encountered:
SQLDescribeCol
SQLGetTypeInfo
SQLColAttribute
We expect that:
(U)Int8 => SQL_TINYINT
(U)Int16 => SQL_SMALLINT
(U)Int32 => SQL_INTEGER
(U)Int64 => SQL_BIGINT
Float32 => SQL_REAL
Float64 => SQL_DOUBLE
FixedString => SQL_CHAR / SQL_BINARY (?)
String => SQL_LONGVARBINARY / SQL_LONGVARCHAR (?)
DateTime => SQL_TYPE_TIMESTAMP / SQL_TYPE_UTCDATETIME (?)
DateTime64 => SQL_TYPE_TIMESTAMP / SQL_TYPE_UTCDATETIME (?)
UUID => SQL_GUID
Decimal => SQL_DECIMAL / SQL_NUMERIC (?)
IPv4 ??
IPv6 ??
LowCardinality(...) => not affect the behavior
All other types => SQL_LONGVARBINARY 'as is' in ODBCDriver2, exception on RowBinary (AggregateFunction state can't be skipped w/o parsing)
https://docs.microsoft.com/en-us/sql/odbc/reference/appendixes/sql-data-types?view=sql-server-ver15
etc.
Table of types mapping (as above) - nice to see the reviewed table in docs.
The text was updated successfully, but these errors were encountered: