Problem:
I have a database that needs to accommodate all languages. Currently it is set to the default latin1_swedish_c1. I’m thinking I need to change it to UTF8, but there are so many UTF8 encodings!
Solution:
“_cs” is for case sensitive collations. So for case insensitive applications you can use utf8_general_ci. utf8_bin is binary so it’s case sensitive.