From PlanetScale’s MySQL for Developers.
Strings
Charset defines what characters can go into a column.
SELECT * FROM information_schema.CHARACTER_SETS ORDER BY CHARACTER_SET_NAME;A collation determines which characters are equal or greater in values in terms of sorting. e.g. is a == A or not? If not which is greater.
- ai = accent insensitive
- ci = case insensitive