|
|
|
|
|
|
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
The floating point data types supported on Alpha/VMS are:
Use the default compiler option /G_FLOAT when compiling programs that are to be linked with Mimer SQL libraries.
Mimer SQL does not currently support D_FLOAT or the use of the two IEEE floats, S_FLOAT and T_FLOAT.
H_FLOAT is also not supported by Mimer SQL on Alpha/VMS since that data type is not supported natively by the Alpha architecture.
Internal Mimer SQL Representation
Mimer SQL uses only two data representations internally: numeric and character. These two types are used to store all data in the database.
The numeric data type stores numbers in packed BCD format with a maximum precision of 45 digits. Every number stored has an exponent with a range of -999 to +999.
The character data type uses the ISO 8859-1 standard character set, also known as Latin 1. This standard specifies graphic characters and the representation of each character.
On most platforms, including OpenVMS, the ISO 8859-1 character set is used by Mimer SQL to transfer data to and from the application, i.e. the same character set as is used internally.
The ISO 8859-1 character set is presented in the Mimer SQL Reference Manual.
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.
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|