Collating data for multiple languages

WebSphere Partner Gateway depends on the underlying databases for collating data. If your installation supports multiple languages and your unicode data is not sorted correctly please review this section.

DB2

WebSphere Partner Gateway 6.0 on DB2 uses the UCA400_NO collating setting. DB2 version 8.2 does not support all special cases (as described in Unicode Standard version 4.00 Technical Standard #10) for all languages. In these instances please contact DB2 directly.

Oracle

Oracle databases allow dynamic changing for collation sequences. In order to utilize this functionality, WebSphere Partner Gateway changes the value of the NLS_SORT session variable depending on the locale of the current user. Table 28 contains possible user locales, supported WebSphere Partner Gateway languages, and their corresponding NLS_SORT values. This information is stored in the PR_LOCALE database table.

Table 28. Locale information
Browser Locale Language NLS_SORT Value
pt_BR Brazil/Portuguese BINARY
zh Chinese SCHINESE_RADICAL_M
en_US English BINARY
fr French FRENCH_M
de German XGERMAN
it Italian BINARY
ja Japanese JAPANESE_M
ko Korean KOREAN_M
es Spanish SPANISH_M
zh_TW Traditional Chinese TCHINESE_RADICAL_M
Other Other BINARY

Copyright IBM Corp. 2003, 2005