Currency and SQLite. REAL or INT?

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

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 …

Currency → Real
Scroll down to datatypes and see the table.