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.

香港美国云服务器首选树叶云，2H2G首月10元开通。
树叶云（shuyeidc.com）提供简单好用，价格厚道的香港/美国云服务器和独立服务器。IDC+ISP+ICP资质。ARIN和APNIC会员。成熟技术团队15年行业经验。