10.1.7.2. Используя COLLATE в SQL-операторах

С ORDER BY:

SELECT kFROM t1ORDER BY k COLLATE latin1_german2_ci;

С AS:

SELECT k COLLATE latin1_german2_ci AS k1FROM t1ORDER BY k1;

С GROUP BY:

SELECT kFROM t1GROUP BY k COLLATE latin1_german2_ci;

С агрегатными функциями:

SELECT MAX(k COLLATE latin1_german2_ci)FROM t1;

С DISTINCT:

SELECT DISTINCT k COLLATE latin1_german2_ciFROM t1;

С WHERE:

     SELECT *     FROM t1     WHERE _latin1 'Müller' COLLATE latin1_german2_ci = k;

     SELECT *     FROM t1     WHERE k LIKE _latin1 'Müller' COLLATE latin1_german2_ci;

С HAVING:

SELECT kFROM t1GROUP BY kHAVING k = _latin1 'Müller' COLLATE latin1_german2_ci;