Hi @Neimneim
Make sure MySQL 4-byte support is enabled in MySQL/MariaDB: Enabling MySQL 4-byte support — Nextcloud latest Administration Manual latest documentation
If it still doesn’t work after that, maybe this thread is of any help: [SOLVED] Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes