Database Mapping of Currency Field type

, ,
1

Dear experts,

I’ve been working through the technical documentation for designers and developers to
find out how the field types of objects fields are mapped to SQL types in database columns.

All I could find was the concept of the “database format”
(http://agileappscloud.info/aawiki/index.php/Database_Format)
which seems to imply that field types Currency, Number, Number with Decimal,
Percent all map to string values of a specific format.
This seems to be consistent with the format/parse functions in the Java API.

Do I understand correctly that these field types map
to a VARCHAR() at the SQL level?

Thanks so much,

Holger

2

Hi Holger,

Below are the MySQL database column types for the respective AA field types

  • Number -int
  • Number with Decimals - double
  • Currency - double
  • Percentage - double

Thanks and Regards
Aparna