database in redmine appliance image created in latin1 encoding instead utf8

[iav]

Database in "redmine" appliance image created in latin1 encoding instead utf8.
This cause non-latin1 characters can't be used, at leas in forums, wiki, project and themes descriptions.

I correct that by dump all databases, replace codepage from latin1 to utf8, and restore bases from this dump.

Redmine-related databases shuold be created with utf8 encoding, and sql server default encoding should be utf8.

[iav (iav)]

Possible solutions for already-created systems:

1. dump mysql databases, replace all "CHARSET=latin1" to "CHARSET=utf8", delete redmine databases, restore redmine databases.

2. convert in-place, for every column:

ALTER TABLE `bitnami_redmine`.`issues` MODIFY COLUMN `subject` BLOB NOT NULL,
MODIFY COLUMN `description` BLOB DEFAULT NULL;

ALTER TABLE `bitnami_redmine`.`issues` MODIFY COLUMN `subject` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
 MODIFY COLUMN `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci.