In this chapter you will learn
• How DB2 identifies and handles the encoding of your XML data
• Best practices to avoid encoding problems
DB2 for z/OS and DB2 for Linux, UNIX, and Windows always store XML data in UTF-8 Unicode, irrespective of the original code page of your XML data or application and regardless of the database code page. If your XML data is in a different encoding, DB2 will automatically perform code page conversion to UTF-8 before storing it. When you retrieve XML data from DB2 you can obtain it in UTF-8 or automatically in the code page of your application. In most cases all code page conversion is fully transparent to your application, especially if you stick to using ...