Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Data types


Data type
SQL data type
MIMER_BINARY
BINARY
MIMER_BINARY_VARYING
BINARY VARYING
MIMER_BLOB
BINARY LARGE OBJECT
MIMER_BOOLEAN
BOOLEAN
MIMER_CHARACTER
CHARACTER
MIMER_CHARACTER_VARYING
CHARACTER VARYING
MIMER_CLOB
CHARACTER LARGE OBJECT
MIMER_DATE *
DATE
MIMER_DECIMAL *
DECIMAL
MIMER_FLOAT *
FLOAT(p)
MIMER_INTEGER
INTEGER(p)
MIMER_INTERVAL_DAY *
INTERVAL DAY
MIMER_INTERVAL_DAY_TO_HOUR *
INTERVAL DAY TO HOUR
MIMER_INTERVAL_DAY_TO_MINUTE *
INTERVAL DAY TO MINUTE
MIMER_INTERVAL_DAY_TO_SECOND *
INTERVAL DAY TO SECOND
MIMER_INTERVAL_HOUR *
INTERVAL HOUR
MIMER_INTERVAL_HOUR_TO_MINUTE *
INTERVAL HOUR TO MINUTE
MIMER_INTERVAL_HOUR_TO_SECOND *
INTERVAL HOUR TO SECOND
MIMER_INTERVAL_MINUTE *
INTERVAL MINUTE
MIMER_INTERVAL_MINUTE_TO_SECOND *
INTERVAL MINUTE TO SECOND
MIMER_INTERVAL_MONTH *
INTERVAL MONTH
MIMER_INTERVAL_SECOND *
INTERVAL SECOND
MIMER_INTERVAL_YEAR *
INTERVAL YEAR
MIMER_INTERVAL_YEAR_TO_MONTH *
INTERVAL YEAR TO MONTH
MIMER_NCHAR
NATIONAL CHARACTER
MIMER_NCHAR_VARYING
NATIONAL CHARACTER VARYING
MIMER_NCLOB
NATIONAL CHARACTER LARGE OBJECT
MIMER_NUMERIC *
NUMERIC
MIMER_T_BIGINT
BIGINT
MIMER_T_DOUBLE
DOUBLE PRECISION
MIMER_T_FLOAT
FLOAT
MIMER_T_INTEGER
INTEGER
MIMER_T_REAL
REAL
MIMER_T_SMALLINT
SMALLINT
MIMER_TIME *
TIME
MIMER_TIMESTAMP *
TIMESTAMP

The data types marked with an asterisk (*) are not supported by the Micro API's data input and data output routines. To use these data types, convert the data using the SQL function CAST.

CAST example

The datecolumn in the table is of data type DATE. Convert it to VARCHAR to be able to read it:

 select cast(datecolumn as varchar(16)) from sometable;

Data input routines

Input data management routines are used to supply input parameter data to statements. The data management routines to set input parameter data are:

Data output routines

The output data management routines used to obtain statement results are:


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX