Locale sensitivity for ordering query results

The query builder APIs order query results by using locale-sensitive comparisons. In contrast, collection enhancement methods for ordering rely on comparison methods built into the Java interface java.lang.Comparable. To sort String values in a locale-sensitive way, you supply an optional Comparator argument to those methods.

Note: In configurations that use primary or secondary linguistic sort strength, the ordering of results is case-insensitive. If either of your PolicyCenter or the relational database that your PolicyCenter uses have these configurations, the query result includes ignores the case of String values. For example, in these configurations, “Building Renovators” and “building renovators” are adjacent in the results.