O'Reilly logo

DB2 by Pav Kumar-Chatterjee, Matthias Nicola

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required