The Crystal Programming Language Forum

MySQL Connection Collation other than utf-8

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

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

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

DROP TABLE table_name; should help with that