Open Stack

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

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[3] 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[1], but they don't look huge.

[1] http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci

- --
Major Hayden
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQIcBAEBCAAGBQJXbSsXAAoJEHNwUeDBAR+x8KYP/01HJ3P2SqjsiUJuMp3zJPV7
y1elLRFC8KnjOwGShRxLYheASTHgszPFhV0SBdynBgVRtpFo3uB7Az1Yzt9hU4lL
dRNhvDChZuSDlMw+6K1w/bzS0p244984t/RIHTd8aqtd10nLE3IeCOMOlvE9FkHO
10r6NoN3NTLkxGmksqyDCTDEXzPBQZ2VYwsAeAKHSAVRGYba4kitYEqs002GvAx7
2GeZrjSb7ZVpAjF1cF4KBTyB0CPaPS1wXzk7yeHQouK8LgbhBKqPGSzBiQkhYRdN
7WohOJTOIqc8T9IgXufUGJbYhQ5CWfHcaESv3a9CHqWCHQsaAx9E0PrMRVAo4Jb1
3DRis03GCw3/+jts3WJR0t21slO5wW/u69BuvSuZ4FjYvJMOprLkufFHXr+j873D
SXwzXFem4ZaxENGtwe2R+bTDchLb2kf9JCgs9RMSnLRX0GmiAaG4XP7SC0Pl10nX
IiWOK5PcL3phlCQRIFn/djTFi8zo7+I1nGXxprNILtBspqzGaZK2NeId0DEQSZpI
+Ycn0YbjNA82ZW6hPwLljWwX5E9Q41Mc5bpwST14oKN9uHRkABMh/YSMg0apRnlI
8nTP1JSHLNsBIu34Ns9zcbvoQF9UsWoX6uIcJSHCbop9kb0ZvWz+UB/Biobm6JY0
wd1HIBAPXpRgsETr4OuL
=63dN
-----END PGP SIGNATURE-----