When i use pyODBC to query a table that contains attributes of type decimal i receive the following error
(‘ODBC SQL type 0 is not yet supported. column-index=0 type=0’, ‘HY106’)
anyone know of a workarounds?
Decimal support is still experimental, and is not enabled by default. Unfortunately there’s also a bug in how data is sent to the ODBC driver.
If possible, please use the JDBC driver instead, or wait for our next server release (which should be available very soon).