Symphony 2.2.3
This is an open discussion with 4 replies, filed under Installation.
Search
Hmm, what version of MySQL do you have, and what charset/collation is your database created with? Make sure it's UTF8.
Hi Nick,
I'm creating the DB like this:
CREATE DATABASE database
DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4generalci;
And I'm using MySQL Server version: 5.5.9
I'm getting this error in Symphony 2.2.4 too!
Thanks, James
Ahh, recreated the database using this and it worked:
CREATE DATABASE database
DEFAULT CHARACTER SET utf8 COLLATE utf8generalci;
Thanks!
You generally don't want to be using utf8mb4
. Unless you need to support a language that requires the extra byte, there is a noticeable degrade in DB performance for using it not to mention it taking up more physical space.
Create an account or sign in to comment.
Hi,
I've just downloaded and attempted an install of 2.2.3 and I'm getting a database error.
Any ideas?
Thanks in advance!
James