SQLite Forum

Decimal128
Login
Hi,

I made a quick search I couldn't find any topic related to Decimal128, so here we go:

Decimal128 (https://en.wikipedia.org/wiki/Decimal128_floating-point_format), not natively supported. I could store the number as text, and search by casting to REAL, but that means I would lose precision, which means the search could yield invalid results.

What could be a workaround for this?

Thanks,
Juan