Double data in ODBC data source became currency after reading into SAS by libname odbc.

[kilasue]

I have a data source whose driver is MariaDB. And the columns are double. But after connecting using libname odbc, they becomes dollar.2 format.

Data in data source:

 

Compare:

The problem is that when I tried to append an SAS dataset into the data source. SAS told me that data types are different:

WARNING: Variable code has format 'DOLLAR.'n on the BASE data set and format 'BEST12.'n on the DATA data set. 'DOLLAR.'n used.

Here base data is the data source. And an error also occurred because one of my column has large values:

CLI execute error: [ma-3.0.3][10.3.9-MariaDB]Out of range value for column 'TCAP' at row 1

[SASKiwi]

Have you made any progress on this? The DBTYPE option might be worth trying:

https://documentation.sas.com/?docsetId=acreldb&docsetTarget=p1dqaq7ub1cm1pn1ow3x9qkmkxe8.htm&docset...