Informix Guide to SQL: Reference
Chapter 2: Data Types
Home
Contents
Index
Master Index
New Book
Data Types
Data Types Supported by Universal Server
Summary of Data Types
Built-In Data Types
Using DATE, DATETIME, and INTERVAL Data
Manipulating DATETIME Values
Manipulating DATETIME with INTERVAL Values
Manipulating DATE with DATETIME and INTERVAL Values
Manipulating INTERVAL Values
Multiplying or Dividing INTERVAL Values
Large-Object Data Types
Smart Large Objects
Simple Large Objects
Extended Data Types
Complex Data Types
Nesting in Complex Data Types
Support Function Inheritance with Complex Data Types
Collection Data Types
Row Data Types
Opaque Data Types
Distinct Data Types
Data Type Casting
Using System-Defined Casts
Converting Number to Number
Converting Between Number and CHAR
Converting Between an Integer and DATE or DATETIME
Converting Between DATE and DATETIME
Using Implicit Casts
Using Explicit Casts
What Extended Data Types Can Be Cast?
Supported Data Types
BLOB
BOOLEAN
BYTE
CHAR(n)
Collating CHAR Data
Multibyte Characters with CHAR
Treating CHAR Values as Numeric Values
Nonprintable Characters with CHAR
CHARACTER(n)
CHARACTER VARYING(m,r)
CLOB
Multibyte Characters with CLOB
DATE
DATETIME
DEC
DECIMAL
DECIMAL Floating Point
DECIMAL Fixed Point
DECIMAL Storage
Distinct Data Type
DOUBLE PRECISION
FLOAT(n)
INT
INT8
INTEGER
INTERVAL
LIST(e)
LVARCHAR
MONEY(p,s)
MULTISET(e)
Named Row Type
Defining Named Row Types
Equivalence and Named Row Types
Named Row Types and Inheritance
Typed Tables
NCHAR(n)
NUMERIC(p,s)
NVARCHAR(m,r)
Opaque Data Type
REAL
SERIAL(n)
Assigning a Starting Value for SERIAL
Using SERIAL with INTEGER
SERIAL8(n)
Assigning a Starting Value for SERIAL8
Using SERIAL8 with INT8
SET(e)
SMALLFLOAT
SMALLINT
TEXT
Nonprintable Characters with TEXT
Multibyte Characters with TEXT
Collating TEXT Data
Unnamed Row Type
Defining Unnamed Row Types
Inserting Values into Unnamed Row Type Columns
VARCHAR(m,r)
Multibyte Characters with VARCHAR
Collating VARCHAR
Nonprintable Characters with VARCHAR
Storing Numeric Values in a VARCHAR Column
Operator Precedence
Informix Guide to SQL: Reference
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
