Home | Previous Page | Next Page   Data Manipulation > Using Numeric Data Types >

Floating-Point Data

A floating-point value is a large decimal value that is stored in a fixed field width. Because the field width is fixed, a floating-point number that is larger than the field width only retains its most significant digits. That is, digits that do not fit into the fixed width are dropped (rounded or truncated).

The DataBlade API provides support for the following kinds of floating-point data (which correspond to existing SQL data types).

Type of Floating-Point Value SQL Data Type
Decimal DECIMAL(p)
True floating-point SMALLFLOAT, FLOAT

These floating-point values have both text and binary representations.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]