Default CCSID
Every application server and application requester has a default CCSID (or default
CCSIDs in installations that support DBCS data). The CCSID of the following
types of strings is determined at the current server:
- String constants (including string constants that represent datetime values)
when the CCSID of the source is in a foreign encoding scheme
- Special registers with string values (such as USER and CURRENT SERVER)
- CAST specifications where the result is a character or graphic string
- Results of CHAR, DATAPARTITIONNAME, DAYNAME, DBPARTITIONNAME, DIGITS,
HEX, MONTHNAME, SOUNDEX, and SPACE scalar functions
- Results of DECRYPT_CHAR, DECRYPT_DB, CHAR, GRAPHIC, VARCHAR, and VARGRAPHIC
scalar functions when a CCSID is not specified as an argument
- Results of the CLOB and DBCLOB scalar functions when a CCSID is not specified
as an argument10
- String columns defined by the CREATE TABLE or ALTER TABLE statements when
an explicit CCSID is not specified for the column10
- String parameters defined by CREATE FUNCTION or CREATE PROCEDURE
statements when an explicit CCSID is not specified for the parameter 10
If one of the types of strings above is used in a CREATE VIEW
statement, the default CCSID is determined at the time the view is created.
In a distributed application, the default CCSID of variables is determined
by the application requester. In a non-distributed application, the default
CCSID of variables is determined by the application server. On i5/OS, the default
CCSID is determined by the CCSID job attribute. For more information about
CCSIDs, see the Work with CCSIDs topic in the Globalization
section of the iSeries Information Center.
If
the default CCSID is 65535, the CCSID used will be the value of the DFTCCSID
job attribute (or an associated CCSID of the DFTCCSID).
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.