db mysql2 database is ootb created with default latin1 character set about cookbook-gitlab-deprecated HOT 3 OPEN

Please see also a sous-chefs/mysql#222

from cookbook-gitlab-deprecated.

That should be the default charset for mysql, I would think. I can take a look into submitting a patch against the mysql, or database, cookbooks this weekend.

from cookbook-gitlab-deprecated.

Well latin1 is probably default for mysql, however all the other attributes are set to UTF8 already. So switching gitlab database to utf8 (or to encoding value from attribute) will make the cookbook ready for an international deployment.

Cmd's to list actual configuration..

mysql> show variables like 'char%';
mysql> show variables like 'collation%';

In my case only character_set_database after the deployment was latin1 (other were utf8). Proper settings might be done on the database cookbook side (setting a default encoding for databases to utf-8) which would fit the most and many other cookbooks/apps would benefit from it. However, honestly, it's a gitlab script that creates the DB and it should properly state it's encoding. (ommitting leads to ootb latin1 and breaks actually the internationall usage at the very begging).

Anyway, my thanks in advance...

from cookbook-gitlab-deprecated.