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

7 votes270 views1 answer
Write a program to find reverse of given number
C
2 votes252 views10 answers
Javascript
C
3 votes241 views2 answers
Gcc compiler for windows 10
C
39 votes334 views5 answers
Fahrenheit to celsius formula
C
0 vote252 views1 answer
Cant update windows
C
0 vote230 views1 answer
National festivals of india in hindi
C
1 vote278 views1 answer
Differnce between spooling and buffering
C
0 vote263 views1 answer
Recursive function in c
C
0 vote261 views1 answer
How to check if a string pointer is empty in c
C
0 vote259 views1 answer
C unused variable
C