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.
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 |