DB2 Version 10.1 for Linux, UNIX, and Windows

Encoding considerations for input of XML data to a database

The internal and external encoding must be considered when storing XML data in a DB2® table.

The following rules need to be observed:

If the internal and external encoding are not Unicode encoding, for externally encoded XML data (data that is sent to the database server using character data types), any internally encoded declaration must match the external encoding. Otherwise, an error occurs, and the database manager rejects the document.
If the external encoding and the internal encoding are Unicode encoding, and the encoding schemes do not match, the DB2 database server ignores the internal encoding.
For internally encoded XML data (data that is sent to the database server using binary data types), the application must ensure that the data contains accurate encoding information.