<< Click to Display Table of Contents >> Navigation:  Tables > Table field types > Money/Currency

MONEY (Currency) fields

Using the MONEY type field may be convenient always displaying only up to two decimals even storing up to six decimals.

However, NEVER trust the automatic currency symbol display if ANY chance of the data being viewed or used outside your current region, as the currency symbol display will always follow the system setting of the PC currently displaying the data - that is to say currency symbol for the very same money data will change when porting the data irrespective of the original currency.

Porting the same data across various regions will display e.g. as follows:

Money data as FLOAT data type

A better and safer way to store money data is to always include the currency designation in the column header name and keeping the field type as some variation of float data type.

__________________________
PdxEditor Application Help, 14 July 2026; © 2010-2026 Niels Knabe