[ISSUE] Installation for database error

[JiaZhou-PU]

Describe the issue Some platforms may have issues with utf8mb4_0900_ai_ci collation.

To Reproduce Follow the ACCERT installation instructions, then run the ./src/accertdb.sql script using MySQLWorkbench before the "Test installation" step.

Expected behavior Expected MySQLWorkbench to execute the file, creating the database and all necessary tables.

Desktop (please complete the following information):

• OS: macOS Ventura 13.3.1 (a) on Apple M1 Chip
• MySQLWorkbech: Version 8.0.31 Community
• MySQL: 5.7.9 MySQL Community Server

Additional context The issue disappears after removing all COLLATE utf8mb4_0900_ai_ci and COLLATE=utf8mb4_0900_ai_ci statements from the accertdb.sql script.

---

For Issue Closure

This review should occur when the issue is going to be closed.

• [ ] 1. Is the defect fixed?
• [ ] 2. If not fixed, does it contain explanation?
• [ ] 3. If closed without a pull request, has an explanation been provided?

[JiaZhou-PU]

@faustotnc could you complete this issue with your error message shown?

[faustotnc]

@faustotnc could you complete this issue with your error message shown?

I have updated it!

[JiaZhou-PU]

Thanks! @faustotnc