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 12‑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 12‑3 Collation implementations
Integration service collation	Database collation	Collation implementation
UNICODE_BIN	unicode_bin	All sort and comparison operations are sent to the database.
UNICODE_BIN	null_sensitive	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.
UNICODE_BIN	null	All operations must be performed by the Integration service.
ASCII_CI	ascii_ci	All sort and comparison operations are sent to the database.
ASCII_CI	null	All operations must be performed by the Integration service.