[openstack-dev] [openstack-ansible] Change of default database collation
major at mhtx.net
Fri Jun 24 12:44:10 UTC 2016
-----BEGIN PGP SIGNED MESSAGE-----
On 06/24/2016 12:07 AM, Jimmy McCrory wrote:
> The question then comes to how to best handle upgrades from Mitaka to Newton.
> Any input for the current proposal from anyone that may have experience with any project's database migration scripts, or MySQL-based databases in general, would be appreciated.
Your proposal looks fine, and from what I read, it seems like the difference between utf8_unicode and utf8_general is mainly around sorting Unicode characters. Then again, I'm no collation/unicode expert, so I'll gladly defer to anyone with more experience there. ;)
Do we know if a change from utf8_unicode_ci to utf8_general_ci will change data in the database? If it doesn't, I'd imagine that a wholesale conversion to utf8_general_ci (as you've proposed in 333733) would be just fine. There are some small performance concerns documented, but they don't look huge.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
-----END PGP SIGNATURE-----
More information about the OpenStack-dev