Home | Previous Page | Next Page

Contents

In This Introduction

About This Manual

Software Dependencies

Assumptions About Your Locale

Demonstration Databases

New Features of Dynamic Server

Character-Representation Conventions

Single-Byte Characters

Multibyte Characters

Single-Byte and Multibyte Characters in the Same String

Whitespace Characters in Strings

Trailing Whitespace Characters

Documentation Conventions

Typographical Conventions

Feature, Product, and Platform

Syntax Diagrams

Example Code Conventions

Additional Documentation

Installation Guides

Informix Error Messages

IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set

Compliance with Industry Standards

IBM Welcomes Your Comments

GLS Fundamentals

In This Chapter

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

In This Chapter

Setting and Retrieving Environment Variables

GLS-Related Environment Variables

DBTIME (ESQL/C)

GL_GLSGLU (IDS)

In This Chapter

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)

Collating Character Data

Using SQL Length Functions

Using Locale-Sensitive Data Types

Handling the MONEY Data Type

Handling Extended Data Types (IDS)

Handling Smart Large Objects (IDS)

Using Data Manipulation Statements

Specifying Conditions in the WHERE Clause

Specifying Era-Based Dates

Loading and Unloading Data

Database Server Features

In This Chapter

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)

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 (ESQL/C)

In This Chapter

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 (ESQL/C)

In This Chapter

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 A. Managing GLS Files

Accessing GLS Files

GLS Locale Files

Locale Categories

Location of Locale Files

Other GLS Files

Code-Set-Conversion Files

The Informix registry File (Windows)

Removing Unused Files

Removing Locale and Code-Set-Conversion Files

Removing Code-Set Files

The glfiles Utility (UNIX)

Listing Code-Set-Conversion Files

Listing GLS Locale Files

Listing Character-Mapping Files

Appendix B. Accessibility

Dotted Decimal Syntax Diagrams

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