The following tables explain possible scenarios that you might in encounter when transferring an XML document between multiple clients and servers.
The following code page combinations are supported:
XML document declaration and encoding | XML Extender clients | DB2 server | Example | ||
---|---|---|---|---|---|
OS locale | Database code page | Document encoding | |||
SJIS | SJIS (Windows or AIX) | SJIS (IBM-943) | 943(SJIS) | SJIS | Windows NT client and server, or Windows NT client and AIX server |
UTF-8 | UTF-8 | UTF-8 | UTF-8 | UTF-8 | Sun client and server, or AIX client and server |
Table 55. Code pages match for client, different on server
XML document declaration and encoding | XML Extender clients | DB2 server | Example | ||
---|---|---|---|---|---|
OS locale | Database code page | Document encoding | |||
SJIS | SJIS (Windows or AIX) | UTF-8 | UTF-8 | UTF-8 | Windows NT client and server, or Windows NT client and AIX server |
UTF-8 | UTF-8 | EUC(IBM-954) | 954(EUC) | EUC | Sun client and server, or AIX client and server |
Because the client code pages are consistent with each other, as well as with the XML document encoding, the server can have a different code page and perform a conversion, without making the XML document encoding statement inconsistent with it's encoding, and with the client.
The following code page scenario is not supported.
Mixed code pages: The code pages for the multiple clients
are not consistent with each other or the XML document, and differ from the
server. DB2 converts the data to the client or server code page
depending on whether it is receiving the document or presenting it to a
client. Because the client code pages and the encoding of the XML
document are not consistent, the encoding of the XML document will not match
its encoding declaration.Table 56 shows sample scenarios.
Table 56. Code pages do not match
XML document declaration and encoding | XML Extender client1 | XML Extender client2 | DB2 server | Example | ||
---|---|---|---|---|---|---|
OS locale | Database code page | Document encoding | ||||
UTF-8 | SJIS (Windows NT or AIX) | EUC (Windows NT or AIX) | UTF-8 | UTF-8 | Data corrupted | Windows NT client and server, or Windows NT client and AIX server |
UTF-8 | SJIS (Sun or AIX) | EUC (Sun or AIX) | EUC(IBM-954) | 954(EUC) | Data corrupted | Sun client and server, or AIX client and server |