Mariadb utf8mb4

# https://scottlinux.com/2017/03/04/mysql-mariadb-set-character-set-and-collation-to-utf8/
# https://mariadb.com/kb/en/library/setting-character-sets-and-collations/
# https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434
# https://stackoverflow.com/questions/47566730/force-mariadb-clients-to-use-utf8mb4

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
collation-server = utf8mb4_unicode_ci
init-connect = 'SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci'
character-set-server = utf8mb4

then checkit with
show variables like 'char%'; show variables like 'collation%';

Source: stackoverflow.com

Similar codes

0 vote149 views1 answer
How to add a number before every line in c language
C
21 votes174 views6 answers
Mkv to mp4
C
-1 vote146 views3 answers
English to russian translation
C
-1 vote154 views8 answers
Do a barrel roll
C
3 votes144 views1 answer
Circle around icon flutter
C
0 vote154 views1 answer
How to print hi in c
C
1 vote148 views1 answer
ERROR: cannot verify nvidia.box.com's certificate, issued by 'CN=GeoTrust RSA CA 2018,OU=www.
C
1 vote235 views1 answer
Arduino knn
C
0 vote144 views1 answer
Postgres login mac
C
1 vote103 views1 answer
Incompatible pointer types passing 'string *' (aka 'char **') to parameter of type 'const char *'; dereference with * [-werror,-wincompatible-pointer-types]
C