Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
GLS User's GuideThe Informix® GLS User's Guide describes the Global Language Support (GLS) feature available in Informix® products.
SQL featuresThese topics explain how the GLS feature affects the Informix® implementation of SQL.
Name database objectsYou must declare names for new database objects (and in some cases, for storage objects, such as dbspaces) when you use data definition language (DDL) statements such as CREATE TABLE, CREATE INDEX, and RENAME COLUMN.
Valid characters in identifiersIn an SQL identifier, a letter can be any character in the alpha class that the locale defines. The alpha class lists all characters that are classified as alphabetic.

Valid characters in identifiers

In an SQL identifier, a letter can be any character in the alpha class that the locale defines. The alpha class lists all characters that are classified as alphabetic.

For more information about character classification, see The CTYPE category. In the default locale, the alpha class of the code set includes the ASCII characters in the ranges a to z and A to Z. SQL identifiers can use these ASCII characters wherever letter is valid in an SQL identifier.

In a nondefault locale, the alpha class of the locale might include non-ASCII characters, such as ideographic characters. When Informix® products use a nondefault locale, SQL identifiers can use non-ASCII characters wherever letter is valid in the syntax of an SQL identifier. A non-ASCII character is also valid for letter as long as this character is listed in the alpha class of the locale.

For the syntax and usage of identifiers in SQL statements, see the Identifier segment in the Informix Guide to SQL: Syntax.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.