What is the currently recommended way to store currency values in s SQLite database? I see the following in the Xojo docs:
Use the REAL data type to store currency values in conjunction with DatabaseRecord.CurrencyColumn and DatabaseField.CurrencyValue.
But I also see others in the forum saying to use INTEGER.
I will definitely need to compare currency values, along with adding and multiplying them. I imagine I can store them as cents in an INTEGER field, and then rely on the UI to convert to 2-digit currency values for display to the user. If I do that, I can rely on SQLite itself to compare values (larger, or smaller than, or equal).