unknow collation: ‘utf8mb4_0900_ai_ci’

Ok, if it's me I am uninstalling, making sure the my.cnf/ini are gone and then re-installing. What are you installing on? Windows or Linux/Ubuntu?

What does SHOW VARIABLES LIKE "version_comment"; show you?

Kortnee Wilson it seems like Eduardo Carrasco 's MySQL 8.2 has been upgraded in place or something along those lines. I did install MySQL 8.2 (through docker) and it does have that collation and I managed to import a SugarCloud cloud 14.2 backup to my local environment without issues.

My suggestion is to Eduardo Carrasco work with his DBA team to have that collation installed (if that's a thing) or simply use containers for this by using our SugarDockerized as his local development environment.

It's new install on windows

SHOW VARIABLES LIKE "version_comment";

Hey Eduardo,

That explains it! MariaDB does not support utf8mb4_0900_ai_ci, which is why you're getting the "Unknown collation" error. Even though you expected MySQL 8.2, you're actually running MariaDB, which lacks this specific collation because it does not follow MySQL’s Unicode collation updates.

Since MariaDB and MySQL are separate projects, the only way to get utf8mb4_0900_ai_ci is to remove MariaDB and install official MySQL.

Just to add to my post I do suggest 8.0.41 and here is a link to the installer on MySQL's website - https://dev.mysql.com/downloads/installer/

When installing make sure the Character Set is utf8mb4 as the default.

we do not support MariaDB unfortunately, as I mentioned earlier, just go with SugarDockerized or install MySQL 8.2.