Handle the MONEY data type

The MONEY data type stores currency amounts. This data type stores fixed-point decimal numbers up to a maximum of 32 significant digits. You can specify MONEY columns in data definition statements such as CREATE TABLE and ALTER TABLE.

The choice of locale affects monetary data in the following ways:
  • The default value of scale in the declaration of MONEY columns
  • The currency notation that the client application uses

The locale defines the default scale and currency notation in the MONETARY category of the locale file. For information about the MONETARY category of the locale file, see The MONETARY category.