Reading Data in Different European Languages With a Single Code Page

Information Builders code page 1252 is based on the Latin script and contains all symbols for the languages of North America, South America, and Western Europe. It is implemented on both the Windows and UNIX platforms. For related information on the Latin script, see Defining Scripts, Languages, and Code Pages.

1. Both data sources use code page 1252. If the two data sources have a common index key with a common range of values, you can join them for reporting. Otherwise, you can make separate requests against each data source.
2. The WebFOCUS Reporting Server is configured to communicate with three client code pages. All Reporting Servers can support multiple client code pages.
3. A request from a client is passed through the NLS API on the WebFOCUS Reporting Server and transcoded into the server code page.
4. Data from the data source is passed through the NLS API and transcoded into the appropriate client code page for the client making the request.
5. This solution works only when data sources use the same code page. In this scenario, code page 1252 handles French and German characters and is available on both the Windows and UNIX platforms. If data sources require different code pages, subservers are needed to combine them.

   For details on combining different code pages with subservers, see Combining Data From Different Code Pages With Subservers.