SQL_DECIMAL not mapped in ODBC::ResultSet#read

[nfesselet]

Hello.
In result_set.cr the col_type value LibODBC::SQL_DECIMAL is not mapped.

This causes a query like select count(*) from table to fail on my informix database.

[naqvis]

@nfesselet Just pushed change to add support for SQL_NUMERIC and SQL_DECIMAL. Make sure you update shard via

shards update

to grab the latest tag.

NB: I don't have access to Informix so unable to validate the changes.

[nfesselet]

@naqvis , Thanks for your quick answer and fix.
However I feel it’s a pity to loose the decimal’s accuracy in converting the value to a float so I tried to come up with my own conversion piece of code. I’m quite new to odbc and I was surprised at how tricky this was. The "official" way using a SQL_NUMERIC_STRUCT seemed to work with informix but gave very strange results with oracle. In the end I found retrieving and converting the string representation the only viable option.