Combining Data From Different Code Pages With Subservers

Data sources using different code pages for the same or different languages can be joined using a WebFOCUS Reporting Server along with subservers. The following describes how transcoding is handled when combining data from different code pages.

1. The two Japanese data sources have a common index key with a common range of values to join them. One data source uses the Shift-JIS code page 942, and the other data source uses the EUC code page 10942.

   • Shift-JIS is PC data. It resides on a Windows subserver.

   • EUC is UNIX data. It resides on a UNIX subserver.

2. While the two subservers have different code page settings, both are configured to communicate with the same client code page (Shift-JIS code page 942). The WebFOCUS Reporting Server is the client for both subservers. Therefore, the server code page setting for the WebFOCUS Reporting Server (Shift-JIS code page 942) is the same as the client code page setting for the subservers (Shift-JIS code page 942).
3. The WebFOCUS Reporting Server is configured to communicate with two client code pages (Shift-JIS code page 942 and UTF-8 Unicode code page 65001).
4. The Windows client could be a browser that is configured to read Shift-JIS, so it reads Japanese data from code page 942. The UNIX client could be a WebFOCUS Client that is configured to read UTF-8 Unicode, so it reads Japanese data from code page 65001.
5. This solution only works when both data source code pages support the same script, in this case, Japanese. You cannot combine Japanese and Chinese data in this way because Japanese and Chinese are different scripts and always use different code pages.

Note: You can also combine unrelated scripts using a Unicode solution. For more information, see What is Unicode? and Combining Data in Unrelated Scripts With Unicode.