Recently, I was working on a small project. When the data table file written by the team member was imported to my local, I reported [err] 1273 – unknown collection: ‘utf8mb4_ 0900_ ai_ Ci ‘error
[Err] 1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
I know it’s the problem of character set encoding, but I changed the encoding of the database to utf8mb4, and then I imported it again. There was no utf8mb4 option when I imported the file
Baidu later found the solution
Solution:
All files in the file will be saved
utf8mb4_ 0900_ ai_ Ci is replaced by utf8_ general_ ci
utf8mb4 is replaced by utf8
Save and run again
Similar Posts:
- The solution of job failed to start when modifying MySQL character encoding
- [Solved] MySQL Error: ERROR 1273 (HY000) at line 199: Unknown collation: ‘utf8mb4_0900_ai_ci’
- [How to Solve Error] warning: LF will be replaced by CRLF in README.md.
- The difference between UTF-8 and utf-8-sig
- How to Solve Mac Sed Error: command c expects followed by text
- node env: node\r: No such file or directory
- [Solved] JMeter Use the JDBC linker Error: Unknown initial character set index ‘255’ received from server.initial client character
- [Solved] {“error_code”:110,”error_msg”:”Access token invalid or no longer valid”}
- utf8mb4_general_Ci error reporting solution