MySQL Connection Collation other than utf-8

Help & Support
1

Which parameters I should use to change connection collation to MySQL?

2

IIRC, this can be done with a query, or updating your my.cnf

[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci 
skip-character-set-client-handshake

Or, run this to set your specific collate:
ALTER DATABASE <database_name> CHARACTER SET utf8 COLLATE utf8_unicode_ci;

More info here:


and

3

It’s a legacy database and can’t alter it. :joy:

4

DROP TABLE table_name; should help with that