Floating-Point Text Representation

Home | Previous Page | Next Page Data Manipulation > Using Numeric Data Types > Floating-Point Data >

Floating-Point Text Representation

The DataBlade API supports a floating-point value in text representation as a quoted string that contains the following characters.

Contents of Integer String	Character
Digits	0–9
Thousands separator: symbol between every three digits	, (comma)
Decimal separator: symbol between the integer and fraction portions of the number	. (period)

For example, the following integer string contains the value for 1,345.77431:

"1,345.77431"

In a floating-point string, the thousands separator is optional.

Important:

Because floating-point numbers retain only their most significant digits, the number that you enter in this type of column and the number the database server displays can differ slightly.

Global Language Support

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 floating-point 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.

End of Global Language Support