My database is currently set to Character set latin1 and Collation latin1_swedish_ci
I am looking for optimal settings which support special characters.
With the Character Set at latin1 there are no utf8 Collation options, so I assume I change the Character set to utf8
Then the following options in screenshots are available
Of these I am guessing I should use one of these but I would like to know rather than guess:
utf8_bin, or utf8_general_ci, utf8_general_mysqli500ci,