• The SQL identifiers that all Informix database servers support

Figure 3-1 lists the SQL identifiers in which all Informix database servers can support non-ASCII characters.

• Some of the SQL identifiers that are unique to Universal Server

Figure 4-3 shows the additional SQL identifiers in which Universal Server can support non-ASCII characters. The SQL Identifier column lists the name of the database object. The SQL Segment column shows the segment that gives the complete syntax of the identifier in the Informix Guide to SQL: Syntax. The Notes column describes any special considerations for the identifier and also provides an example of an SQL statement that creates or uses the identifier.

Figure 4-3
SQL Identifiers Unique to INFORMIX-Universal Server That Support Non-ASCII Characters

(1 of 2)

SQL Identifier	SQL Segment	Notes
Cast	Expression	An example of an SQL statement that uses a cast name is CREATE CAST.
Distinct data type	Data Type	An example of an SQL statement that uses a distinct-data-type name is CREATE DISTINCT.
Function	Function Name	An example of an SQL statement that uses a function name is CREATE FUNCTION.
Opaque data type	Data Type	An example of an SQL statement that uses a opaque-data-type name is CREATE OPAQUE TYPE.
Operator class	Expression	An example of an SQL statement that uses a operator-class name is CREATE OPCLASS.
Procedure	Procedure Name	An example of an SQL statement that uses a procedure name is CREATE PROCEDURE.
Row data type	Data Type	An example of an SQL statement that uses a row data type name is CREATE ROW TYPE.