Home | Previous Page | Next Page

Contents

About This Manual

Software Dependencies

Assumptions About Your Locale

Demonstration Databases

New Features of Dynamic Server

Documentation Conventions

Typographical Conventions

Feature, Product, and Platform

Syntax Diagrams

Example Code Conventions

Additional Documentation

Installation Guides

Informix Error Messages

Related Reading

Compliance with Industry Standards

IBM Welcomes Your Comments

GLS Fundamentals

Using the GLS Feature

GLS Support by IBM Informix Products

Understanding a GLS Locale

Code Sets for Character Data

Character Classes of the Code Set

Collation Order for Character Data

End-User Formats

Setting a GLS Locale

Locales in the Client/Server Environment

The Default Locale

Setting a Nondefault Locale

Using GLS Locales with IBM Informix Products

Supporting Non-ASCII Characters

Establishing a Database Connection

Performing Code-Set Conversion

Locating Message Files

Customizing End-User Formats

Customizing Date and Time End-User Formats

Customizing Monetary Values

GLS Environment Variables

Setting and Retrieving Environment Variables

GLS-Related Environment Variables

DBNLS (IDS Only)

DBTIME (E/C Only)

Naming Database Objects

Rules for Identifiers

Non-ASCII Characters in Identifiers

Valid Characters in Identifiers

Using Character Data Types

Localized Collation of Character Data

Other Character Data Types

Handling Character Data

Specifying Quoted Strings

Specifying Comments

Specifying Column Substrings

Specifying Arguments to the TRIM Function

Using Case-Insensitive Search Functions (IDS Only)

Collating Character Data

Using SQL Length Functions

Using Locale-Sensitive Data Types

Handling the MONEY Data Type

Handling Extended Data Types (IDS Only)

Handling Smart Large Objects (IDS Only)

Using Data Manipulation Statements

Specifying Conditions in the WHERE Clause

Specifying Era-Based Dates

Loading and Unloading Data

Database Server Features

GLS Support by Informix Database Servers

Database Server Code-Set Conversion

Data That the Database Server Converts

Locale-Specific Support for Utilities

Non-ASCII Characters in Database Server Utilities

Non-ASCII Characters in SQL Utilities

Locale Support For C User-Defined Routines (IDS and DB API Only)

Current Processing Locale for UDRs

Non-ASCII Characters in Source Code

Copying Character Data

The IBM Informix GLS Library

Code-Set Conversion and the DataBlade API

Locale-Specific Data Formatting

Internationalized Exception Messages

Internationalized Tracing Messages

Locale-Sensitive Data in an Opaque Data Type

General SQL API Features

Supporting GLS in IBM Informix Client Applications

Client Application Code-Set Conversion

Internationalizing Client Applications

Internationalization

Handling Locale-Specific Data

Processing Characters

Formatting Data

Avoiding Partial Characters

IBM Informix ESQL/C Features

Handling Non-ASCII Characters

Using Non-ASCII Characters in Host Variables

Generating Non-ASCII Filenames

Using Non-ASCII Characters in ESQL/C Source Files

Defining Variables for Locale-Sensitive Data

Using Enhanced ESQL/C Library Functions

DATE-Format Functions

DATETIME-Format Functions

Numeric-Format Functions

String Functions

GLS-Specific Error Messages

Handling Code-Set Conversion

Writing TEXT Values

Using the DESCRIBE Statement

Using the TRIM Function

Appendix. Managing GLS Files

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