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 vote331 views1 answer
C program for airthmetic operators
C
0 vote402 views1 answer
Mediawiki upload size
C
0 vote402 views2 answers
How to determine the level of each node in the given tree?
C
0 vote408 views1 answer
Code to reverse the words in a sentnce
C
29 votes451 views1 answer
Best sites for coding challenges
C
3 votes386 views3 answers
Regex in rails
C
0 vote404 views1 answer
Conditional compilation in c
C
0 vote405 views1 answer
WARNING: QA Issue: bgslibrary-dev rdepends on libopencv-imgproc, but it isn't a build dependency, missing opencv in DEPENDS or PACKAGECONFIG? [build-deps]
C
0 vote388 views1 answer
3.Write a program that has a class student that stores roll number, name, and marks (in three subjects) of the students. Display the information (roll number, name, and total marks) stored about the student?
C
0 vote414 views1 answer
Fgets em c
C