Home | Previous Page | Next Page

Data Types

In This Chapter

Summary of Data Types

Description of Data Types

BIGINT (XPS Only)

BLOB (IDS Only)

BOOLEAN (IDS Only)

Treating CHAR Values as Numeric Values

Sorting and Relational Comparisons

Nonprintable Characters with CHAR

CHARACTER VARYING(m,r)

CLOB (IDS Only)

Multibyte Characters with CLOB

DECIMAL(p) Floating Point

DECIMAL (p,s) Fixed Point

DECIMAL Storage

Distinct (IDS Only)

DOUBLE PRECISION

LIST(e) (IDS Only)

LVARCHAR(m) (IDS Only)

MULTISET(e) (IDS Only)

Opaque (IDS Only)

ROW, Named (IDS Only)

Defining Named ROW Types

Equivalence and Named Row Types

Named Row Types and Inheritance

ROW, Unnamed (IDS Only)

Creating Unnamed Row Types

Inserting Values into Unnamed Row Type Columns

Assigning a Starting Value for SERIAL8

Using SERIAL8 with INT8

SET(e) (IDS Only)

Nonprintable Characters in TEXT Values

Nonprintable Characters with VARCHAR

Storing Numeric Values in a VARCHAR Column

Multibyte Characters with VARCHAR

Collating VARCHAR Values

Built-In Data Types

Large-Object Data Types

Simple Large Objects

Smart Large Objects (IDS Only)

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 (IDS Only)

Complex Data Types

Collection 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 Character

Converting Between INTEGER and DATE

Converting Between DATE and DATETIME

Using User-Defined Casts

Determining Which Cast to Apply

Casts for Distinct Types

What Extended Data Types Can Be Cast?

Operator Precedence

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]