Informix Guide to GLS Functionality SQL Features

Naming Database Objects

Rules for Identifiers

Non-ASCII Characters in Identifiers

SQL Segments

Owner Names

Delimited Identifiers

Valid Characters in Identifiers

Using Character Data Types

Locale-Specific Character Data

The NCHAR Data Type

The NVARCHAR Data Type

Performance Considerations

Other Character Data Types

The CHAR Data Type

The VARCHAR Data Type

The LVARCHAR Data Type

The TEXT Data Type

Handling Character Data

Specifying Quoted Strings

Specifying Comments

Specifying Column Substrings

Column Substrings in Single-Byte Code Sets

Column Substrings in Multibyte Code Sets

Partial Characters in Column Substrings

Misinterpreting Partial Characters

Partial Characters in an ORDER BY Clause

Specifying Arguments to the TRIM Function

Using Case-Insensitive Search Functions

Collating Character Data

Collation Order in CREATE INDEX

Collation Order in SELECT Statements

Comparisons with MATCHES and LIKE Conditions

Using SQL Length Functions

The LENGTH Function

The OCTET_LENGTH Function

The CHAR_LENGTH Function

Using Locale-Sensitive Data Types

Handling the MONEY Data Type

Specifying Values for the Scale Parameter

Format of Currency Notation

Handling Extended Data Types

Opaque Data Types

Complex Data Types

Distinct Data Types

Handling Smart Large Objects

Using Data Manipulation Statements

Specifying Conditions in the WHERE Clause

Specifying Era-Based Dates

Loading and Unloading Data

Loading Data into a Database

Unloading Data from a Database

Loading with External Tables

Loading Simple Large Objects with External Tables