The text representation of a fixed-point value is a quoted string that contains a series of digits. The DataBlade API supports a text representation for both decimal and monetary values.
The DataBlade API supports a decimal value in text representation as a quoted string that contains the characters that the following table shows.
A decimal value in its text representation is often called a decimal string. For example, the following decimal string contains the value for 1,345.77:
"1,345.77"
In a decimal string, the thousands separator is optional.
A locale defines the end-user format for numeric values. The end-user format is the format in which data appears in a client application when the data is a literal string or character variable. The preceding decimal string is the end-user format for the default locale, U.S. English. A nondefault locale can define an end-user format that is particular to a country or culture outside the U.S. For more information, see the IBM Informix: GLS User's Guide.
The DataBlade API supports a monetary value in text representation as a quoted string that contains the characters that the following table shows.
A monetary value in its text representation is often called a monetary string. For example, the following money string contains the value for $1,345.77:
"$1,345.77"
In a monetary string, the thousands separator and the currency symbol are optional. You can change the format of the monetary string with the DBMONEY environment variable.
A locale defines the end-user format for monetary values. The end-user format is the format in which data appears in a client application when the data is a literal string or character variable. The preceding monetary string is the end-user format for the default locale, U.S. English. A nondefault locale can define monetary end-user formats that are particular to a country or culture outside the U.S. For more information, see the IBM Informix: GLS User's Guide.