MySQL Error number: 3778; Symbol: ER_WARN_DEPRECATED_UTF8MB3_COLLATION; SQLSTATE: HY000 报错 故障修复 远程处理

文档解释

Error number: 3778; Symbol: ER_WARN_DEPRECATED_UTF8MB3_COLLATION; SQLSTATE: HY000

Message: ‘%s’ is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.

Error Number 3778: ER_WARN_DEPRECATED_UTF8MB3_COLLATION

Error Explanation: This error is raised in MySQL when warnings are being generated because an attempt has been made to use a deprecated or unsupported utf8mb3 collation.

Common Case: This error is commonly encountered in the following scenarios: when attempting to use an old or outdated utf8mb3 collation, when trying to set a deprecated or unsupported utf8mb3 collation for a character set, and when using a deprecated or unsupported utf8mb3 collation in a DDL statement.

Resolution: To resolve this error, use a more recent utf8mb4 collation instead of a utf8mb3 collation. The utf8mb4 collation is the new default collation for the utf8 character set in MySQL 5.5.3 and higher, so upgrading to a newer version of MySQL will likely resolve this issue automatically.