Focus on that “collations” error, that’s your problem. You solve it in phpMyAdmin or some other database admin tool.
just set the database collation to “utf8_general_ci”, that’s the standard, I think.
You might have to do it for individual tables, I am not sure. In another thread I saw this command:
ALTER TABLE users_cstm CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;