Confluence does not support the database collation "utf8_general_ci". You need to use "utf8_bin".

if you use this character set, the Chinese will be garbled. I don"t know what to do

.

the database I connected to with jdbc

jdbc:mysql://192.168.1.100:3306/confluence?charset=utf8&sessionVariables=tx_isolation="READ-COMMITTED"

Jan.08,2022

try

ALTER DATABASE confluence CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER DATABASE confluence CHARACTER SET utf8 COLLATE utf8_unicode_ci;
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3768f-2c0a5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3768f-2c0a5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?