By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| txt_ai_ci | txt_ai_ci LIKE 'Gr%' | txt_as_cs | txt_as_cs LIKE 'Gr%' | txt_as_cs COLLATE utf8mb4_0900_ai_ci LIKE 'Gr%' |
|---|---|---|---|---|
| GREEN | 1 | GREEN | 0 | 1 |
| Green | 1 | Green | 1 | 1 |
| green | 1 | green | 0 | 1 |