How to replace it from “utf8mb4_general_ci” to “utf8mb4_unicode_ci” by default?
I think problem is here in query
For example
SET NAMES utf8mb4;
CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
It needs to be added as a new feature…
Can be added via mariadb server settings
Warning
User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. As of MySQL 8.0.33, the server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued when the server is started with --collation-server set equal to the name of a user-defined collation.
Mysql Is about to drop support for it…
1 Like
Hello @hestia,
As @eris said, you can modify conf manually, collation_server directive is here:
/etc/mysql/mariadb.conf.d/50-server.cnf
Cheers,
sahsanu
but doesn’t work
my.cnf
this problem has been around for many years, I can’t do anything about it, only change the encoding manually every time after creating the database, I’m just tired of doing this…
Update my.cnf
1 Like