Table of Contents

Search

  1. Preface
  2. XML Concepts
  3. Using XML with PowerCenter
  4. Working with XML Sources
  5. Using the XML Editor
  6. Working with XML Targets
  7. XML Source Qualifier Transformation
  8. Midstream XML Transformations
  9. XML Datatype Reference
  10. XPath Query Functions Reference

XML Guide

XML Guide

Code Pages

Code Pages

XML files contain an encoding declaration that indicates the code page used in the file. The most common code pages in XML are UTF-8 and UTF-16. All XML parsers support these code pages. For information on the XML character encoding specification, see the W3C website at http://www.w3c.org.
PowerCenter supports the same set of code pages for XML files that it supports for relational databases and other flat files. PowerCenter does not support a user-defined code page.
When you create an XML source or target definition, the Designer assigns the PowerCenter Client code page to the definition. If you import an XML schema that contains a code page assignment, the XML Wizard displays the code page from the schema. However, the XML Wizard does not apply that code page to the XML definition you create in the repository.
You can not configure the code page for an XML source definition. The Integration Service converts XML source files to Unicode when it parses them.
You can configure the code page for a target XML definition in the Designer. You can also change the code page for an XML target instance in session properties.

0 COMMENTS

We’d like to hear from you!