Prisma

What is the recommended way of storing currency? Would normally use `Decimal`, but it loses its precision.

Example: Value 97.85 turns into 97.8499999999999900

We convert all currency to cents and store as integers.

So in your example we would store 97.85 as 9750

Quick division 9750/100 gets us back to 97.85.

This is also how <http://stripe.com|stripe.com> handles it.

Thanks for your help. I really appreciate it!!

Glad to help!

Also, just noticed I made a typo in the math but I think you get the point :slightly_smiling_face:

Was wondering  why my entire machine blew up! :wink:

<@U02HVEB459A> This works for dealing with Prisma. But then the numbers get messed up when during the conversion from currency to integer!

Example: 151.92 * 100 = 15191.999999999998 :man-shrugging:

The amount of work just to get a correct decimal! :smile: