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 vote327 views2 answers
C convert float to string
C
0 vote314 views1 answer
To run Blazor project using CLI
C
0 vote358 views1 answer
C question mark
C
0 vote321 views1 answer
Cut first part of string c
C
0 vote318 views1 answer
Semicolong after for() loop stackoverflow
C
0 vote313 views1 answer
Assets/Scripts/UIManager.cs(65,13): error CS0201: Only assignment, call, increment, decrement, await, and new object expressions can be used as a statement
C
0 vote343 views1 answer
Writing tests for API requests
C
1 vote343 views1 answer
Add border to image android
C
0 vote299 views1 answer
Notation of positive in c
C
3 votes345 views1 answer
Error: 'for' loop initial declarations are only allowed in C99 or C11 mode
C