在MySQL中,utf8mb3_general_ci 和utf8mb4_general_ci 是两种不同的字符集校对规则。utf8mb3 是utf8 的一个子集,它使用3个字节来表示一个字符,而 utf8mb4 使用4个字节,能够表示更多的字符(包括一些特殊的Unicode字符,如表情符号)。因此,从 utf8mb3_general_ci 转换到 utf8mb4_general_ci 可以让你的数据...
最后我像这样决定
`displayname` FROM `oc_users` `u` LEFT JOIN `oc_preferences` `p` ON (`userid` = `uid`) AND (`appid` = 'settings') AND (`configkey` = 'email') WHERE (`uid` COLLATE utf8mb4_general_ci LIKE ?) OR (`displayname` COLLATE utf8mb4_general_ci L...
Syntax error or access violation: 1253 COLLATION 'utf8mb4_ general_ci' is not valid for CHARACTER SET 'utf8mb3 Ok, somewhere along the way I must have noticed the warning MySQL is used as database but does not support 4-byte characters. To be able to ...