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


Chapter 3 Data Interpretation : Collation

Collation
Collating Sequence
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.
Example
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.
Collation Behavior
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:
Using the IBM‑037 code page, école is sorted before femme (‘école’ < ‘femme’)
Using the IBM‑297 code page, femme is sorted before école (‘femme’ < ‘école’)
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.
Characters Affected
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.

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