Informix Guide to GLS Functionality
Chapter 3: SQL Features
Home
Contents
Index
Master Index
New Book
SQL Features
Naming Database Objects
Rules for Identifier Names
Identifiers That Support Non-ASCII Characters
References to SQL Segments
Owner Name in SQL Identifiers
Valid Characters in Identifier Names
Non-ASCII Characters in Delimited Identifiers
Multibyte Characters and Identifier Length
Using Character Data Types
The NCHAR Data Type
Collating NCHAR Data
Handling NCHAR Data
Multibyte Characters with NCHAR
Treating NCHAR Values as Numeric Values
Nonprintable Characters with NCHAR
The NVARCHAR Data Type
Collating NVARCHAR Data
Handling NVARCHAR Data
Multibyte Characters with NVARCHAR
Nonprintable Characters with NVARCHAR
Storing Numeric Values in an NVARCHAR Column
Performance Considerations for NCHAR and NVARCHAR
Other Character Data Types
The CHAR Data Type
The VARCHAR Data Type
The TEXT Data Type
Collating Character Data
Collation Order in CREATE INDEX
Collation Order in SELECT Statements
The ORDER BY Clause
Logical Predicates in a WHERE Clause
Comparisons with MATCHES and LIKE Conditions
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
Specifying Arguments to the TRIM Function
Using SQL Length Functions
The LENGTH Function
With Single-Byte Code Sets
With Multibyte Code Sets
The OCTET_LENGTH Function
The CHAR_LENGTH Function
Handling MONEY Columns
Default Values for the Scale Parameter
Format of Currency Notation
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
Informix Guide to GLS Functionality
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
