The following sections explain how to compile applications using floating point data types, and what data types Mimer SQL uses internally and externally.
Compiling Applications Using Floating Point Data Types
OpenVMS supports various floating point types. Mimer SQL uses the types that the C compiler uses as default. Unfortunately, this differs between the Alpha and Integrity platforms.
|
F_FLOAT |
4 bytes |
Used by Mimer on Alpha |
|---|---|---|
|
S_FLOAT |
4 bytes |
Used by Mimer on Integrity |
|
G_FLOAT |
8 bytes |
Used by Mimer on Alpha |
|
T_FLOAT |
8 bytes |
Used by Mimer on Integrity |
|
D_FLOAT |
8 bytes |
Not supported by Mimer |
|
H_FLOAT |
16 bytes |
Not supported by Mimer |
External Data Types Supported by Mimer SQL
Any value stored in the database may be read into host language variables as described in the Mimer SQL Programmer’s Manual.
Mimer SQL will perform all the necessary conversions and will signal an error if the value to be converted is not compatible with the destination type.