通过 COLLATE 子句,你可以在比较时覆盖替换掉任何默认collation, COLLATE 可以用
在SQL 语句的很多部分里,这里是一些例子:
1、在 ORDER BY 里:
select k FROM t1 ORDER BY k COLLATE latin1_german2_ci; |
2、在 AS 里:
select k COLLATE latin1_german2_ci AS k1 FROM t1 ORDER BY k1; |
3、在GROUP BY里 :
select k FROM t1 GROUP BY k COLLATE latin1_german2_ci; |
4、在集合函数里:
select MAX(k COLLATE latin1_german2_ci) FROM t1; |
5、在DISTINCT里
select DISTINCT k COLLATE latin1_german2_ci FROM t1; |
6、在where 里:
select * FROM t1 where _latin1 'Müller' COLLATE latin1_german2_ci = k; |
7、在HAVING里:
select k
FROM t1
GROUP BY k
HAVING k = _latin1 'Müller' COLLATE latin1_german2_ci;