unee-t / bugzilla-customisation

Unee-T's customisation on top of Bugzilla
https://hub.docker.com/r/uneet/bugzilla-customisation/
GNU Affero General Public License v3.0
5 stars 7 forks source link

Update bugzilla code to support utf8 collation #80

Closed kaihendry closed 5 years ago

kaihendry commented 5 years ago

Issues that are plaguing like like:

Are because though we manually updated our schema to utf8mb4 / utf8mb4_unicode_520_ci. Bugzilla stable release which we rely on, hasn't updated its connection parameters and code to support the schema.

Fixing this

There are a couple of paths forward:

Either we somehow update Bugzilla stable's Perl codebase to support Unicode schema ourselves. Or we adopt the new version of Bugzilla called Harmony that supports Unicode.

Migrating to Harmony sounds attractive, but it appears to introduce a lot of complexity that we already have encapsulated in our Meteor Frontend project. Furthermore Harmony doesn't appear nearly as stable as Bugzilla 5.0.6.

Both options depend on @dylanwh's expertise and hopefully he will weigh in with a proposal over the weekend. This issue is just to document the situation we have.

kaihendry commented 5 years ago

The https://github.com/bugzilla/bugzilla/tree/synthesis branch is addressing this and under test now and will probably be merged into our Bugzilla docker image.

kaihendry commented 5 years ago

This is underway https://github.com/unee-t/frontend/issues/850#issuecomment-518118111