Approximate numeric data types

Adaptive Server Enterprise differs from Adaptive Server Anywhere and Sybase IQ in how the FLOAT(p) data type is interpreted: that is, when to create a 4-byte data type, and when to create an 8-byte data type.

Adaptive Server Anywhere and Sybase IQ offer the FLOAT_AS_DOUBLE option to control data width.