SQLite Forum

Timeline
Login

7 forum posts by user naklers

2020-06-20
13:29 Reply: Decimal128 (artifact: dbafc5ddad user: naklers)

+1 :)

13:26 Edit reply: Decimal128 (artifact: ef6109d9a4 user: naklers)

Thanks Warren. It's complicated :) We are trying to replicate server data on mobile devices, and the server has been supporting Decimal128 for some time now...

13:25 Edit reply: Decimal128 (artifact: 3c73cb32bb user: naklers)

I'm sure going to pass on this information :D

13:19 Reply: Decimal128 (artifact: bcee2945e4 user: naklers)

I'm sure going to pass this information :D

13:17 Reply: Decimal128 (artifact: 6bfad961e6 user: naklers)

Thanks Warren. It's complicated :) We are trying to replicate server data on mobile devices, and the server has been supported Decimal128 for some time now...

2020-06-19
17:23 Reply: Decimal128 (artifact: 538b6b2616 user: naklers)

Thanks Warren for the suggestions, and you are right. I can hardly imagine how this is useful in the business domain but unfortunately it is not my decision..

10:44 Post: Decimal128 (artifact: 6599970f43 user: naklers)

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