Sorting Entries for Non-English Locales

You can correct sorting problems in IBM® Cognos® Connection in locales other than English for an Oracle or Microsoft SQL content store..

To correct a sorting problem, use the CM.SortCollation parameter. For example, to sort entries in an Oracle database using a Chinese phonetic collation, set CM.SortCollation parameter to SCHINESE_PINYIN_M.

For information about supported collations, see the Oracle and SQL Server documentation. Setting the CM.SortCollation value has no effect on Content Manager running against DB2® or Sybase databases.