Informix Guide to SQL: Reference Data Types

In This Chapter

Summary of Data Types

Description of Data Types

BLOB

BOOLEAN

BYTE

CHAR(n)

CHARACTER(n)

CHARACTER VARYING(m,r )

CLOB

DATE

DATETIME

DEC

DECIMAL

Distinct

DOUBLE PRECISION

FLOAT(n)

INT

INT8

INTEGER

INTERVAL

LIST(e)

LVARCHAR

MONEY(p,s)

MULTISET(e)

Named Row

NCHAR(n)

NUMERIC(p,s)

NVARCHAR(m,r)

Opaque

REAL

Row, Named

Row, Unnamed

SERIAL(n)

SERIAL8

SET(e)

SMALLFLOAT

SMALLINT

TEXT

Unnamed Row

VARCHAR(m,r)

Built-In Data Types

Large-Object Data Types

Simple Large Objects

Smart Large Objects

Time Data Types

Manipulating DATETIME Values

Manipulating DATETIME with INTERVAL Values

Manipulating DATE with DATETIME and
INTERVAL Values

Manipulating INTERVAL Values

Multiplying or Dividing INTERVAL Values

Extended Data Types

Complex Data Types

Collection Data Types

Row Data Types

Distinct Data Types

Opaque Data Types

Data Type Casting and Conversion

Using Built-in Casts

Converting from Number to Number

Converting Between Number and CHAR

Converting Between INTEGER and DATE or DATETIME

Converting Between DATE and DATETIME

Using User-Defined Casts

Implicit Casts

Explicit Casts

Determining Which Cast to Apply

Casts for Distinct Types

What Extended Data Types Can Be Cast?

Operator Precedence