Homec4science

Use utf8_general_ci for "sort" columns in old MySQL

Authored by epriestley <git@epriestley.com> on Feb 26 2015, 19:18.

Description

Use utf8_general_ci for "sort" columns in old MySQL

Summary:
Fixes T7287. This trades off 4-byte character support for case insensitivity in these columns, which is a much better trade on the balance.

Also adds more warnings about old MySQL. Note that we already issue a warning when you run "storage adjust" (which I've made stronger) and already "strongly recommend" MySQL 5.5 or newer in the install documentation.

Test Plan:

  • Ran storage adjust --disable-utf8mb4 to go to old definitions, then ran storage adjust to get back to the new ones. Everything seemed OK in both cases.
  • Verified that utf8mb4 data can be migrated out of these colums with --unsafe (which will truncate).
  • Verified that manual explains this.
  • Faked my way into the setup warning.

Reviewers: btrahan

Reviewed By: btrahan

Subscribers: epriestley

Maniphest Tasks: T7287

Differential Revision: https://secure.phabricator.com/D11893

Details

Committed
epriestley <git@epriestley.com>Feb 26 2015, 19:18
Pushed
aubortJan 31 2017, 17:16
Parents
rPH1236043472ce: Make base font a Celerity CSS variable
Branches
Unknown
Tags
Unknown

Event Timeline

epriestley <git@epriestley.com> committed rPH9e82cfcc214b: Use utf8_general_ci for "sort" columns in old MySQL (authored by epriestley <git@epriestley.com>).Feb 26 2015, 19:18