Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 2 Character and Code Page Support : Supported Code Pages

Supported Code Pages
EBCDIC Code Pages
The following EBCDIC (CECP) code pages are supported:
IBM‑037
IBM‑1140
IBM‑273
IBM‑1141
IBM‑277
IBM‑1142
IBM‑278
IBM‑1143
IBM‑280
IBM‑1144
IBM‑282
IBM‑284
IBM‑1145
IBM‑285
IBM‑1146
ASCII Code Page
The following ASCII code pages are supported: ISO8859‑1, ISO8859‑15, and WIN‑1252. These code pages are supported for ASCII display and communication and are used by Windows and Solaris.
These code pages remap the ASCII to EBCDIC translation of two characters. The two characters are the EBCDIC logical-not character (¬), which is remapped to the ASCII circumflex (^), and the EBCDIC pipe character (¦), which is remapped to the ASCII bar character (|). With the exception of these special characters, any character can be entered in user data fields.
The ISO8859‑1 and ISO8859‑15 code pages, as used in TIBCO Object Service Broker, are subsets of the Windows CP1252 (default) character set. Refer to Code Page ISO8859‑1 for a copy of the ISO8859‑1 code page.
All ISO-8859-1 characters use the same code points as those in CP1252. However, CP1252 contains characters that do not exist in ISO-8859-1 (or in Latin-1 EBCDIC). When TIBCO Object Service Broker encounters an unsupported (ASCII) character, it performs a reciprocal translation; that is, provided the input ASCII and output ASCII are both CP1252, the desired character is preserved. For example, the euro symbol, which does not exist in either IBM‑037 or ISO‑8859‑1 and which is at x'80' in CP1252, is translated to a unique non‑display code point in IBM‑037 EBCDIC and back to x'80' on output to CP1252.
The WIN-1252 code page is recommended since it contains code points for both the Universal Currency Symbol (UCS) at x'A4' and the euro at x'80', while the ISO-8859-1 code page and the ISO-8859-15 code page are missing one or the other.
TDS Code Pages
The valid TDS code pages are as follows:
IBM‑037 or IBM-1140
National Language Support for External Database Servers
You can connect an external database server on one platform to a Data Object Broker running on the other platform using a different code page.
To specify the default code pages for specific table types or server IDs, use the @SERVERCONFIG table. In this parameterized table:
Adding a Server Type
To add a server type to the table:
1.
The following appears:

 
EDITING TABLE : @SERVERCONFIG
 
ENTER PARM VALUE SERVERTYPE :
ENTER PARM VALUE LOCATION :

 
2.
The following appears:

 
EDITING TABLE : @SERVERCONFIG(_NT)
COMMAND ==>
SCROLL: P
NAME TYPE SYNTAX LENGTH DECIMAL
_ ---------------- - - ------ ------

 
3.
4.
The information should be the same as the example below, replacing NAME and VALUE with the appropriate information for your server type.

 
--- SINGLE OCCURRENCE EDITOR ---
EDITING TABLE : @SERVERCONFIG
TABLE TYPE : TDS
COMMAND ==>
-------------------------------------------------------
NAME : DB2
TYPE :
SYNTAX : C
LENGTH : 32
DECIMAL : 0
VALUE : ESPA.IBM-284
MODIFY : N
ALLOWED_VALUES :

 
Adding a Server ID
To enter information for a server ID, use the same procedure with “_NS” as the server type option.
The information should be the same as the example below, replacing NAME and VALUE with the appropriate information for your server ID.

 
--- SINGLE OCCURRENCE EDITOR ---
EDITING TABLE : @SERVERCONFIG
TABLE TYPE : TDS
COMMAND ==>
-------------------------------------------------------
NAME : DB2PROD
TYPE :
SYNTAX : C
LENGTH : 32
DECIMAL : 0
VALUE : ESPA.IBM-284
MODIFY : N
ALLOWED_VALUES :

 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved