7. Embedded SQL for Pascal : Pascal Variables and Data Types : Data Type Conversion
 
Share this page                  
Data Type Conversion
A Pascal variable declaration must be compatible with the Ingres value it represents. Numeric Ingres values can be set by and retrieved into numeric variables, and Ingres character values can be set by and retrieved into character string variables.
Data type conversion occurs automatically for different numeric types, as follows:
From floating-point Ingres database column values into integer Pascal variables
From decimal to floating-point
From floating-point to decimal
For different length character strings, such as from varying-length Ingres character fields into fixed-length Pascal character string variables
Ingres does not automatically convert between numeric and character types. You must use the Ingres type conversion functions, the Ingres ascii function, or a Pascal conversion procedure for this purpose.