XML in a Non-Unicode Database: Handle Code Page Conversion in XML Data in DB2 for Linux, UNIX, and Windows

Overview

This paper explains how to use the XML native data type in a non-Unicode database in DB2 Viper 2. The paper provide tips on how to avoid substitution characters, pointers for query structuring and character reference usage, and explanations of the new utility User-Defined Functions (UDFs) shipping with the product. In DB2 9, the only way to include XML data in a database was to have a UTF-8 code set for the database. This restriction was true even if the XML data included only ASCII code points. XML is stored in the database in a binary format, and the text nodes are stored as UTF-8 code points.