Unicode support in player names

[amj]

e.g. https://agagd.usgo.org/player/24898/

[vash3g]

Person in example shows up with correct name in membership manager. Looks like a display issue for AGAGD.

[gregsteltenpohl]

• This bug looks to be caused by the default charset for the databases being:
  • CHARACTER SET latin1 COLLATE latin1_swedish_ci
• These are shown in the schema, even though under General Settings, utf8mb_unicode_ci is the "Server connection collation".
• This is likely an artifact from when the AGAGD was first acquired from the EGF.
• We should be able to update this value to:
  • CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci (looks like we are on version 5.7 of MySQL)
• Please review the following documentation before making changes, as the CHARACTER SET we choose can affect things like varchar value comparisons and sorting (eg. a and á may or may not be treated as equivalent)
  • https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
• See this comment on StackOverflow for additional context and things to watch for:
  • https://stackoverflow.com/questions/367711/what-is-the-best-collation-to-use-for-mysql-with-php/25475756#25475756