#4884 - Support for CURRENCY data field (on hold)

This is a spacer post for a website comment topic. The content this topic relates to: #4884 - Support for CURRENCY data field (on hold)
An alternative is to support a new REAL_DOUBLE data field type, once #3046 is implemented (i.e. once we know we can use it in PHP code). This solves the problem of inflated currencies, and reduces the chance of accuracy errors - but it is not as clean.
Or, to use BIGINT, once #3046 is implemented and deal in cents. Probably not very future proof and somewhat messy.

For reference, I looked into it and MySQL 32 bit can handle BIGINT (64 bit), DOUBLE (64 bit), and very long DECIMAL up to 65 digits. This is because it uses either advanced CPU instructions or compiler magic to work beyond the system architecture's word size.
0 guests and 0 members have recently viewed this.