The collating sequence of a remote peer request can differ from that of a local request for the same data if the code page of the remote TDS table differs from that of the local TDS table.
For example, consider the French words école and
femme. When represented in code page IBM‑037, the first letter of each word is represented as code points 0x51 and 0x86. However, in the French EBCDIC code page IBM‑297 the first letters are represented as code points 0xC0 and 0x86.
For sorting character data, TIBCO Object Service Broker uses the binary machine representation of the data items to determine the sort order. Therefore, the following inconsistent sorting behavior occurs:
This collation behavior is an important consideration in requests for character data in explicit or implicit sort operations and can impact peer requests across systems with differing values of the TDS code page.
In general, the collating behavior of characters in the English alphabet (a‑z, A‑Z) and the numeric characters 0‑9 are the same in all currently supported EBCDIC code pages. Characters other than these could collate differently when represented in different EBCDIC code pages.