Data Types Used in Mimer SQL

 

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.