Working with international data

Db2 handles different character sets in distributed data through character conversions.

Character conversion concepts
Character data that is transmitted from one DBMS to another might need to be converted to a different coded character set.
System-coded character set identifiers
To support character conversion, the IBM® Distributed Relational Database Architecture™ (DRDA) uses CCSIDs to label the various character representation schemes.
How an entry in SYSIBM.SYSSTRINGS works with character conversion
The catalog table SYSIBM.SYSSTRINGS contains information about character conversion. Each row in the table describes a conversion from one coded character set to another.
Conversion-related changes that require remote packages to be rebound
Certain conversion-related changes at the local DBMS or at a remote DBMS might force the rebinding of a package.
Locales for uppercase and lowercase conversion of EBCDIC data
Rules for uppercase and lowercase usage vary according to language and country. A locale defines the subset of a user's environment that depends on language and cultural conventions.
Setting up z/OS to allow uppercase and lowercase conversion of Unicode and ASCII data
If you want to use the UPPER or LOWER built-in functions to process Unicode and ASCII data, you must complete additional setup. You must also complete additional setup if you want to use uppercase or lowercase conversions for characters other than A–Z or a–z.

Parent topic: Installing or migrating to Db2 12