Hello and best wishes for a happy and prosperous new year.

I have an issue with com_comments!

Trying to install "CComment Pro 6.1.5" on a joomla 4 environment but this is not possible. During installation i get the following error:
COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8'
Error installing component

3 database tables are created:
bwpdn_compojoom_customfields InnoDB utf8_general_ci
bwpdn_compojoom_customfields_cats InnoDB utf8_general_ci
bwpdn_compojoom_multimedia InnoDB utf8_general_ci

1 folder is created in: media/com_comment (empty)

Can you please advise?

Thank you in advance