10.5.1. SQL ¸í·É¹®¿¡¼ COLLATE »ç¿ëÇϱâ
COLLATE ±¸¹®À» »ç¿ëÇϸé, ºñ±³¿ë µðÆúÆ® ÄÝ·¹¼ÇÀ» ¹«½ÃÇÒ ¼ö ÀÖ°Ô µÈ´Ù. COLLATE ´Â SQL ¸í·É¹®ÀÇ ´Ù¾çÇÑ ºÎºÐ¿¡¼ »ç¿ëµÇ¸ç, ¸î °¡Áö ¿¹¹®ÀÌ ¾Æ·¡¿¡ ÀÖ´Ù:
SELECT k
FROM t1
ORDER BY k COLLATE latin1_german2_ci;
SELECT k COLLATE latin1_german2_ci AS k1
FROM t1
ORDER BY k1;
SELECT k
FROM t1
GROUP BY k COLLATE latin1_german2_ci;
SELECT MAX(k COLLATE latin1_german2_ci)
FROM t1;
SELECT DISTINCT k COLLATE latin1_german2_ci
FROM t1;
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;
SELECT k
FROM t1
GROUP BY k
HAVING k = _latin1 'Müller' COLLATE latin1_german2_ci; |