MySQL Support BigDecimal originally

[BigtoC]

I am working on a project that required read/write BigDecimal data, like 12345.123456789123456789.
But while I'm using SQLDelight, it rounds my number to 12345.1234568, my numbers lost precisions.
Even I implemented ColumnAdapter, it just converts the data from db to double, then convert to BigDecimal, still losing precisions.

Hope will fix in the future release🙏 Thanks!

[angusholder]

Which underlying database are you using? (SQLite/MySQL/Postgres/..)

If SQLite, it has no support for arbitrary precision numbers and there's nothing SQLDelight can change about that, so your only option is to store the BigDecimal as a string

[BigtoC]

Which underlying database are you using? (SQLite/MySQL/Postgres/..)

If SQLite, it has no support for arbitrary precision numbers and there's nothing SQLDelight can change about that, so your only option is to store the BigDecimal as a string

I am using MySQL 5.7

[AlecKazakova]

related: #1882