Page MenuHomePhabricator

CloudVPS: m5-master databases for openstack may require re-encoding
Open, HighPublic

Description

When upgrading neutron database schema from Mitaka to Newton, we had several encoding issues related to latin1.

We may need to re-encode the database to something more sensible (like utf8 or whatever).

Event Timeline

aborrero triaged this task as High priority.Mon, Oct 7, 3:36 PM
aborrero created this task.
aborrero moved this task from Inbox to Important on the cloud-services-team (Kanban) board.
Marostegui moved this task from Triage to In progress on the DBA board.Mon, Oct 7, 3:37 PM
Penggang1 set Due Date to Mon, Oct 7, 4:00 PM.Mon, Oct 7, 4:09 PM
Penggang1 removed Due Date.
Penggang1 removed subscribers: Aklapper, Krenair, Bstorm and 7 others.
bd808 added a comment.Tue, Oct 8, 4:19 PM

utf8 is probably not the 'right' encoding. Mysql's utf8 is only capable of 3-byte code points. latin1 and utfmb4 would both work for 4-byte code points like 🦄.

Andrew renamed this task from CloudVPS: m5-master databases for openstack may require re-enconding to CloudVPS: m5-master databases for openstack may require re-encoding.Tue, Oct 15, 4:37 PM