About collation implementations
Together, the Integration service collation and the database collation determine which operations are sent to the database and which operations must be performed by the Integration service, as shown in Table 13-3. If the database would not perform an operation in the same way as the Integration service, the operation must be performed by the Integration service.
Table 13-3  
Integration service collation
Database collation
GROUP BY and SELECT DISTINCT operations, DISTINCT aggregations, LIKE, POSITION, and string equality (=) comparisons are sent to the database.
ORDER BY on strings, string comparisons other than equality, MAX, MIN, etc. must be performed by the Integration service.

Additional Links:

Copyright Actuate Corporation 2012