1.1.1

REAL
Provides 4-byte storage for numbers using IEEE floating-point notation.
Arithmetic operations do not round their resulting values to zero. If the values are too small, you will receive an
exception. Constants always map to DOUBLE – use an explicit CAST to convert a constant to REAL.
For behavior with other types in expressions, see Numeric type promotion in expressions, Storing values of one
numeric data type in columns of another numeric data type.
The maximum/minimum limits are different from those of java.lang.Float as noted below.
java.lang.FloatEquivalent Java type
-3.402E+38Minimum value
3.402E+38Maximum value
1.175E-37Smallest positive value
-1.175E-37Largest negative value
java.sql.Types.REALJDBC metadata type
ResultSet.getFloat, PreparedStatement.setFloatJDBC methods
System.SingleEquivalent .NET type
Vmware.Data.SQLFire.SQLFType.RealADO.NET metadata type
SingleADO.NET mapped System.Data.Dbtype
DbDataReader.GetFloatADO.NET getter
Examples
–- examples of valid values
values cast (233.31E3 as REAL);
values cast (8928E+06 as REAL);
-- this example will throw a range exception (SQLState: "42820")
values cast (123456789012345678901234567890123456789e0 as REAL);
SMALLINT
Provides 2 bytes storage for short integer values.
For behavior with other types in expressions, see Numeric type promotion in expressions, and Storing values of
one numeric data type in columns of another numeric data type.
java.lang.ShortEquivalent Java type
java.lang.Short.MIN_VALUE (-32768 )Minimum value
java.lang.Short.MAX_VALUE (32767)Maximum value
java.sql.Types.SMALLINTJDBC metadata type
ResultSet.getShort, PreparedStatement.setShortJDBC methods
System.Int16Equivalent .NET type
Vmware.Data.SQLFire.SQLFType.ShortADO.NET metadata type
Int16ADO.NET mapped System.Data.Dbtype
631
SQL Language Reference