Currency and SQLite. REAL or INT?

General
1

The Xojo docs here say to use the REAL datatype in an SQLite database to store a Xojo Currency datatype.

However this thread tells that Currency should be stored as INTEGER.

Which is it and what are the implications if Xojo currency values have been stored in a DOUBLE (REAL) field in an SQLite database?

Thank you

2

if you use an int you will have no rounding errors
if you use a double, prepare to fight for any cents or part of cents every time you sum some values …

3

Currency → Real

http://documentation.xojo.com/index.php/SQLiteDatabase
Scroll down to datatypes and see the table.