MySQL - Unknown collation: 'utf8mb4_0900_ai_ci'

PHPMaker General Discussion (PHPMaker)
1

i tryto test on the phpmaker demo project, but when i import the demo Db mysql show an error:Error
Static analysis:1 errors were found during analysis.Unrecognized statement type. (near “DEFAULT” at position 167)
SQL query: Copy-- Dumping database structure for demo2021 CREATE DATABASE IF NOT EXISTS demo2021.sql /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci / /!80016 DEFAULT ENCRYPTION=‘N’ */MySQL said: Documentation#1273 - Unknown collation: ‘utf8mb4_0900_ai_ci’

2

christ2000 wrote:

#1273 - Unknown collation: ‘utf8mb4_0900_ai_ci’

You better use MySQL 8.0.1 or newer.

3

i delete this for line 16:/*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci / /!80016 DEFAULT ENCRYPTION=‘N’

now i can import

4

You may not delete it. Just change it to utf8mb4_general_ci.