MySQL parser requires charset names defined as tokens. Not all available charsets are currently supported by the grammar.
The list of all MySQL supported charsets is available at https://dev.mysql.com/doc/refman/8.0/en/charset-charsets.html andd its subchapters.
The test should verify the charset itself and one of collations.
This is follow-up to