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

2 votes144 views1 answer
Mariadb unknown collation: 'utf8mb4_0900_ai_ci'
C
0 vote143 views1 answer
How to sort assending in c
C
0 vote134 views1 answer
#include <iostream> using namespace std; int main() { for(int i=3;i!=0; i--) { count<<i--<<" "; } }
C
0 vote144 views1 answer
C question mark
C
0 vote129 views1 answer
C zero out array
C
1 vote140 views2 answers
React-textfit
C
0 vote135 views1 answer
Worst case
C
2 votes140 views6 answers
How to print hello world in c
C
0 vote173 views1 answer
'keras.backend' is not a package
C
0 vote147 views1 answer
How to sort an int array in c
C