Slide 10
Slide 10 text
文字列比較
文字列比較
なんでやねん!
というのを説明
SELECT * FROM tbl WHERE utf8mb4_col = _ascii'ABC' => ⭕
SELECT * FROM tbl WHERE ascii_col = _utf8mb4'ABC' => ⭕
SELECT * FROM tbl WHERE ascii_col = _utf8mb4'ほげ' => ❌
ERROR 1267 (HY000): Illegal mix of collations (ascii_general_ci,
IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation '='
10