Database should support the configured character set and collation Error

Permalink
Anytime I try to installed a fresh version of concrete5 (composer version). I keep getting this error

The database does not have a complete support for all the Unicode characters. This implies, for example, that you may not be able to save emoticons (it's the same behavior as concrete5 versions older than 8.5.0). You should upgrade your database to fix this issue.


When I click on "ignore warning" check box, install stops and comes up with a long database error. This is happening on my local development environment using Laragon. I have updated MySQL Library to version 8.0 and I using PHP version 7.3.2.

The strangest issue is I have this exact setup on my Windows 10 laptop and don't get this error.

stewblack23
View Replies: View Best Answer
JohntheFish replied on at Permalink Reply
JohntheFish
Could be the database character set. utf8mb4, collation utf8mb4generalCI (not sure of the case and punctuation of those)
stewblack23 replied on at Permalink Reply 1 Attachment
stewblack23
I normally select utf8mb4generalC for my collation type and everything works fine.

I have also enclosed a screenshot of the error when trying to write to the database at install.
JohntheFish replied on at Permalink Reply
JohntheFish
The screenshot refers to utf8. Not utf8mb4.
Bash669 replied on at Permalink Best Answer Reply
You might also need to make sure that your collation and character set are properly defined at your my.cnf file (e.g. using character-set-server = utf8mb4 collation-server = utf8mb4_bin)


http://www.targetehr.me/
stewblack23 replied on at Permalink Reply
stewblack23
I figured out the actual issue. I forgot to add the correct user permissions to the new user I created. Once I did that and add your variables to the my.ini file. I was able to install the DB as normal.