Informix Guide to GLS Functionality
Chapter 3: SQL Features

Home Contents Index Master Index New Book

In This Chapter

This chapter explains how the GLS feature affects the Informix implementation of SQL. It describes how the choice of a locale affects the following topics:

The names you use for database objects in data definition statements such as CREATE TABLE and CREATE INDEX
The behavior of character data types such as CHAR, VARCHAR, NCHAR, and VARCHAR
Collation order in the CREATE INDEX and SELECT statements
The use of non-ASCII characters in quoted strings, comments, column substrings, and the TRIM function in SELECT and other statements
The behavior of the MONEY data type
The SQL length functions
The behavior of data manipulation statements such as INSERT, DELETE, and UPDATE and load statements

For descriptions of SQL features that are not unique to the GLS feature, see the Informix Guide to SQL: Syntax. For additional information on the Informix implementation of SQL, consult the Informix Guide to SQL: Reference and the Informix Guide to SQL: Tutorial.

The information in this chapter pertains to all Informix database servers. INFORMIX-Universal Server extends the functionality of relational databases to object-oriented relational database with the creation of new data types. For information about how these new data types might affect global language support, see Chapter 4, "INFORMIX-Universal Server Features."

Informix Guide to GLS Functionality, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.