Chapter 20. Understanding XML Data Encoding

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 ...

Get DB2 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.