Resolved C-Type not supported error during INSERT statement
Details
| Detail name | Value |
|---|---|
| Changelog Number | 30329 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | ODBC 24.2.0 |
| Fix Versions | ODBC 26.2.7 |
| Resolution Date | 2026-06-30 |
Description
In ODBC driver versions between 24.2.0 and 26.2.6, inserting NULL into numeric columns through prepared parameters could fail with SI002 / C-Type not supported error. This happened when the client bound the value type as SQL_C_DEFAULT, for example when binding Python None via pyodbc.
Workaround
A lower version than 24.2.0 of ODBC driver can be used.
Fix
Fixed default parameter type mapping in ODBC prepared parameter binding. When the value type is SQL_C_DEFAULT, the driver now derives the C value type from the SQL parameter type.
