• Understanding DB2 Universal Database character conversion (IBM, PDF)

• DB2 UDB National Language Support for the Command Line Processor and Utilities (IBM,PDF)

• When code page conversion occurs (DB2 V9.7 Info Center)

• Supported territory codes and code pages (DB2 V9.7 Info Center)

Ermittlung der Codepage-Einstellungen mit dem DB2 Command “db2 -a connect to ….”.

FOR BIT DATA werden wie Daten mit Codepage=0 verschlüsselt verarbeitet.

Beachte: The IBM DB2 Driver for JDBC and SQLJ returns data from a ResultSet.getString call for a CHAR FOR BIT DATA or VARCHAR FOR BIT DATA column as a lowercase hexadecimal string.

Displaying/selecting [VAR]CHAR FOR BIT DATA table columns:

SELECT CAST(COL_FOR_BIT_DATA AS [VAR]CHAR(nn) FOR SBCS DATA)  
FROM YOURTABLE

What ist the codepage of a table column – querying the DB2 catalog:
(FOR BIT DATA columns are shown with CODEPAGE=0)

SELECT COLNAME, TYPENAME,  CODEPAGE FROM SYSCAT.COLUMNS
WHERE TABNAME = 'YOURTABLE'

• Unicode Standards: www.unicode.org
• Unicode Standard: An Overview
• Introduction to Unicode (ICU User Guide) (Source Forge Net)
• Unicode Support speziell für DB2 z/OS Version 8:
• All for One and One for All – Introducing Unicode, Part 1 and Part 2 (Quelle: IBM UK)
• DB2 UDB for z/OS Internationalization Guide (IBM, FTP, PDF)
• II13049: SUPPORT FOR UNICODE: STEPS FOR INSTALLING AND  CUSTOMIZING (PART 2)
• II13048: SUPPORT FOR UNICODE: STEPS FOR INSTALLING AND  CUSTOMIZING (PART 1)
• The secret life of Unicode (IBM)
• Understanding DB2 Universal Database character conversion (IBM, PDF)
• DB2 UDB National Language Support for the Command Line Processor and Utilities (IBM)