Hi all, OpenStack-Ansible has been configuring the default database collation as 'utf8_unicode_ci'. We've recently run into an issue with new deployments during cinder database migrations where a foreign key column had different a collation between the parent and child table[1]. That's since been fixed, and we're now looking at changing the default collation to match the default of MySQL/MariaDB's utf8 character set to avoid the possibility of this same discrepancy with new deployments[2]. The question then comes to how to best handle upgrades from Mitaka to Newton. Any input for the current proposal[3] from anyone that may have experience with any project's database migration scripts, or MySQL-based databases in general, would be appreciated. Also, Have any of the other deployment projects been effected by this? Are there any in-progress efforts to help further enforce a standard character set and collation through DB migration scripts? Thanks [1] https://bugs.launchpad.net/cinder/+bug/1594195 [2] https://review.openstack.org/#/c/331786/ [3] https://review.openstack.org/#/c/333733/ -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20160623/f706704b/attachment.html>