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 vote127 views1 answer
Write a program in c to count total number of alphabets, digits and special characters in a string
C
0 vote133 views3 answers
Hello World in C language
C
1 vote167 views3 answers
Strcpy c
C
-2 votes152 views1 answer
Jupyter notebook collapse cell
C
0 vote177 views1 answer
Iterating through a linked list
C
0 vote142 views1 answer
47D:\Code Testing\Hello World.cpp[Error] 'result' was not declared in this scope
C
0 vote130 views1 answer
Email dev Microsoft Outlook 2007 items all aligned left or aligned wrong
C
17 votes153 views2 answers
Write in file in c
C
0 vote169 views1 answer
Ecto where is not nil
C
0 vote209 views1 answer
File "rs_to_open3d.py", line 19, in <module> point cloud = Point Cloud() NameError: name 'PointCloud' is not defined
C