yes, that query works, and the SQL Type for that calculated column is now SQL_NUMERIC (instead of SQL_INTEGER) according to python. So I have a workaround !
In the meantime I also checked with ODBC and the result there is the same as with JDBC: evertyhing seems to work as it should. This probably means the pythonbind interface is not doing some conversions that the ODBC and JDBC drivers are doing ?
Hi,
yes, that query works, and the SQL Type for that calculated column is now SQL_NUMERIC (instead of SQL_INTEGER) according to python. So I have a workaround !
In the meantime I also checked with ODBC and the result there is the same as with JDBC: evertyhing seems to work as it should.
This probably means the pythonbind interface is not doing some conversions that the ODBC and JDBC drivers are doing ?
So should this be reported as a bug ?