• 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 VF9.1)

• Unterstützte Gebietscodes und Codepages (DB2 V9.1)

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.

Anzeigen von [VAR]CHAR FOR BIT DATA Tabellenspalten:
SELECT CAST(COL_FOR_BIT_DATA AS [VAR]CHAR(nn) FOR SBCS DATA)  FROM YOURTABLE

Wie sind die Columns codiert - Abfrage des DB2 Catalogs: (FOR BIT DATA haben CODEPAGE=0)
SELECT COLNAME, TYPENAME,  CODEPAGE
FROM SYSCAT.COLUMNS
WHERE TABNAME = 'YOURTABLE'
 

• Unicode Standards: www.unicode.org

• Unicode Standard: A Technical Introduction
• Introduction to Unicode (ICU User Guide) (Source Forge Net)

• Unicode Support speziell für DB2 z/OS Version 8:

• DB2 for z/OS Version 8: The Migration Process (Quelle: IBM)
• DB2 for z/OS Version 8: Planning for Migration (Quelle: IBM)
• All for One and One for All - Introducing Unicode, Part 1 and Part 2 (Quelle: IBM UK)
• DB2 UDB for z/OS & OS/390 V8 Unicode Support (IBM Technical Conference, PDF)
• 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)