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
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.
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.
Could be the database character set. utf8mb4, collation utf8mb4generalCI (not sure of the case and punctuation of those)
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.
I have also enclosed a screenshot of the error when trying to write to the database at install.
The screenshot refers to utf8. Not utf8mb4.
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/
http://www.targetehr.me/
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.
