How do I fix 'Incorrect character set' errors

Donovan Torgerson

Hello,

I'm trying to setup confluence and mysql Docker containers.

I have them both building successfully but when I try to set up confluence, I get this error:

Incorrect character set

Your database must be configured to use utf8 as the default character set. Learn more

 

I've specified the character set in the docker-compose file like this:

command: [mysqld, --character-set-server=utf8, --collation-server=utf8_bin, --default-storage-engine=INNODB, --max_allowed_packet=256M, --innodb_log_file_size=2GB, --transaction-isolation=READ-COMMITTED, --binlog_format=row]

I've also tried setting it in the database url like this:

jdbc:mysql://mysql/db?useUnicode=true&characterEncoding=utf8

 

Any help would be much appreciated!

 

Donovan Torgerson

I was able to resolve this issue myself. I had added the character-set-server and collation-server to the mysqld command in the docker-compose.yml file but for some reason that wasn't being used in the rebuild when using docker-compose up.  Being as I am just getting started and had nothing in the database, I was able to remove the shared folder on the host that contained all the mysql files and used docker-compose up --force-recreate which resolved the issue.