Re: Wrong database collation / utf8mb4 encoding for emoticons in subject line
Michiel Beijen <[email protected]> Wed, 20 Jun 2018 11:58:55 +0200
| Newsgroups | gmane.comp.otrs.devel |
|---|---|
| Message-ID | <CABD0r11yK4f1xVNUZJS=z733MzydFfCrQX0eeebcxtwcuxdwKA@mail.gmail.com> |
SGksCgp1dGY4bWI0IGlzIHRoZSBvbmx5IGNoYXJhY3RlciBzZXQgd2hpY2ggY2FuIGNvbnRhaW4g YWxsIFVURjgKY2hhcmFjdGVycywgZXNwZWNpYWxseSA0LWJ5dGUgY2hhcmFjdGVycyBzdWNoIGFz IGVtb2ppcyBjYW4ndCBiZQpzdG9yZWQgaW4gJ3V0ZjgnLiBTZWUKaHR0cHM6Ly9tZWRpdW0uY29t L0BhZGFtaG9vcGVyL2luLW15c3FsLW5ldmVyLXVzZS11dGY4LXVzZS11dGY4bWI0LTExNzYxMjQz ZTQzNAoKU28gaXQgc2VlbXMgbGlrZSB0aGlzIHNob3VsZCBiZSB0aGUgY29sbGF0aW9uIHRvIHVz ZSBpbiBPVFJTLgpIb3dldmVyIHRoZXJlIGlzIG9uZSBpbmRleCB3aGljaCBpcyB0b28gbGFyZ2Ug Zm9yIHVzZSBvbiB1dGY4bWI0CmNvbGxhdGlvbiwgd2hpY2ggaXMgd2h5IE9UUlMgZGV2ZWxvcGVy cyBjaG9zZSBmb3Igbm93IHRvIHN0aWNrIHdpdGgKdXRmOC4gU2VlIHRoaXMgYnVnIHJlcG9ydDog aHR0cHM6Ly9idWdzLm90cnMub3JnL3Nob3dfYnVnLmNnaT9pZD0xMjM2MQoKCm9mIGNvdXJzZSwg eW91IGNvdWxkIGFsc28ganVzdCBkcm9wIHRoaXMgaW5kZXggKHByb2JhYmx5LCB5b3Ugd29uJ3QK bmVlZCBpdCA6RCkgYW5kIHVzZSB1dGY4bWI0LiBNb3N0IHByb2JhYmx5LCB5b3UnbGwgYmUgZmlu ZS4uLgoKLS0KTWljaGllbAoKT24gV2VkLCBKdW4gMjAsIDIwMTggYXQgMTA6NTkgQU0sIE9UUlMt QWRtaW5pc3RyYXRpb24KPG90cnMtYWRtaW4ua2ltQHVuaS1rb25zdGFuei5kZT4gd3JvdGU6Cj4g RGVhciBsaXN0IG1lbWJlcnMKPgo+IHdlJ3ZlIHJlY2VudGx5IGluc3RhbGxlZCBPVFJTIHZlcnNp b24gNi4wLjggKENvbW11bml0eSBFZGl0aW9uKSBvbiBhIERlYmlhbgo+IExpbnV4IHN5c3RlbTku NCB3aXRoIE15U1FMLS9NYXJpYS1EQiAxNS4xIGFuZCBBcGFjaGUgV2Vic2VydmVyIDIuNC4yNSBh cwo+IHdlbGwgYXMgIFBlcmwgNSwgdmVyc2lvbiAyNC4gVGhlIGluc3RhbGxhdGlvbiBwcm9jZXNz IHdlbnQgZmluZSB1bnRpbCB3ZQo+IHJlYWNoZWQgdGhlIHBvaW50IHRvIGluaXRpYWxpemUgT1RS UycgZGF0YWJhc2Ugd2l0aCBDR0ktU2tyaXB0IGluc3RhbGxlci5wbC4KPiBUaGUgaW5zdGFsbGVy IHJlcG9ydHM6Cj4KPiAiV3JvbmcgZGF0YWJhc2UgY29sbGF0aW9uIChjaGFyYWN0ZXJfc2V0X2Rh dGFiYXNlIGlzIHV0ZjhtYjQsIGJ1dCBpdCBuZWVkcwo+IHRvIGJlIHV0ZjgpLiIKPgo+IFRoZSBk ZWZhdWx0IGNoYXJhY3RlciBlbmNvZGluZyBvbiBNeVNRTC0vTWFyaWEtREIgaXM6Cj4KPiBNYXJp YURCIFsobm9uZSldPiBTSE9XIFZBUklBQkxFUyBXSEVSRSBWYXJpYWJsZV9uYW1lIExJS0UKPiAn Y2hhcmFjdGVyXF9zZXRcXyUnIE9SIFZhcmlhYmxlX25hbWUgTElLRSAnJWNvbGxhdGlvbiUnOwo+ Cj4gKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tKwo+IHwg VmFyaWFibGVfbmFtZSAgICAgICAgICAgIHwgVmFsdWUgICAgICAgICAgICAgIHwKPiArLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0rCj4gfCBjaGFyYWN0ZXJf c2V0X2NsaWVudCAgICAgfCB1dGY4bWI0ICAgICAgICAgICAgfAo+IHwgY2hhcmFjdGVyX3NldF9j b25uZWN0aW9uIHwgdXRmOG1iNCAgICAgICAgICAgIHwKPiB8IGNoYXJhY3Rlcl9zZXRfZGF0YWJh c2UgICB8IHV0ZjhtYjQgICAgICAgICAgICB8Cj4gfCBjaGFyYWN0ZXJfc2V0X2ZpbGVzeXN0ZW0g fCBiaW5hcnkgICAgICAgICAgICAgfAo+IHwgY2hhcmFjdGVyX3NldF9yZXN1bHRzICAgIHwgdXRm OG1iNCAgICAgICAgICAgIHwKPiB8IGNoYXJhY3Rlcl9zZXRfc2VydmVyICAgICB8IHV0ZjhtYjQg ICAgICAgICAgICB8Cj4gfCBjaGFyYWN0ZXJfc2V0X3N5c3RlbSAgICAgfCB1dGY4ICAgICAgICAg ICAgICAgfAo+IHwgY29sbGF0aW9uX2Nvbm5lY3Rpb24gICAgIHwgdXRmOG1iNF9nZW5lcmFsX2Np IHwKPiB8IGNvbGxhdGlvbl9kYXRhYmFzZSAgICAgICB8IHV0ZjhtYjRfZ2VuZXJhbF9jaSB8Cj4g fCBjb2xsYXRpb25fc2VydmVyICAgICAgICAgfCB1dGY4bWI0X2dlbmVyYWxfY2kgfAo+ICstLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLSsKPgo+IERvIHdlIGdl dCByaWQgb2YgdGhpcyBlcnJvciBieSBzZXR0aW5nIGNoYXJhY3Rlcl9zZXRfZGF0YWJhc2UgdG8g dXRmOCBvbmx5Pwo+Cj4gSW4gdGhlIHBhc3Qgd2UgZW5jb3VudGVyZWQgcHJvYmxlbXMgd2l0aCBu ZXcgZS1tYWlsIHRoYXQgY29tZXMgaW50byB0aGUgT1RSUwo+IHRpY2tldCBzeXN0ZW0gYW5kIGNv bnRhaW5zIG5hc3R5IGVtb3RpY29ucyBpbiB0aGUgc3ViamVjdCBsaW5lOiBhcyBhIHJlc3VsdAo+ IHRoZSBPVFJTIHN5c3RlbSByZWZ1c2VzIHRvIGltcG9ydCBhbnkgZW1haWwgYW55bW9yZS4gU28g d2UgZG8gdGhpbmsgaXQgaXMKPiB1c2VmdWwgdG8ga2VlcCB0aGUgdXRmOG1iNCBlbmNvZGluZyBp biB0aGUgZGF0YWJhc2UgYmVjYXVzZSB3aXRoIHRoaXMKPiBlbmNvZGluZyB0aGUgZGF0YWJhc2Ug aXMgY2FwYWJsZSB0byBoYW5kbGUgdGhlIGluY29taW5nIGVtb3RpY29ucyBpbiBzdWJqZWN0Cj4g bGluZS4KPgo+IEJlc3QgcmVnYXJkcywKPgo+IE1hcmt1cwo+Cj4KPiAtLQo+IE9UUlMtQWRtaW5p c3RyYXRpb24KPiBVbml2ZXJzaXTDpHQgS29uc3RhbnoKPiBLb21tdW5pa2F0aW9ucy0sIEluZm9y bWF0aW9ucy0sIE1lZGllbnplbnRydW0gKEtJTSkKPiBBYnRlaWx1bmdlbiBLSU0tQmFzaXNkaWVu c3RlLCBLSU0tU3VwcG9ydAo+IDc4NDU3IEtvbnN0YW56LCBEZXV0c2NobGFuZAo+Cj4gX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KPiBPVFJTIG1haWxpbmcg bGlzdDogZGV2IC0gV2VicGFnZTogaHR0cDovL290cnMub3JnLwo+IEFyY2hpdmU6IGh0dHA6Ly9s aXN0cy5vdHJzLm9yZy9waXBlcm1haWwvZGV2Cj4gVG8gdW5zdWJzY3JpYmU6IGh0dHA6Ly9saXN0 cy5vdHJzLm9yZy9tYWlsbWFuL2xpc3RpbmZvL2RldgpfX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fXwpPVFJTIG1haWxpbmcgbGlzdDogZGV2IC0gV2VicGFnZTog aHR0cDovL290cnMub3JnLwpBcmNoaXZlOiBodHRwOi8vbGlzdHMub3Rycy5vcmcvcGlwZXJtYWls L2RldgpUbyB1bnN1YnNjcmliZTogaHR0cDovL2xpc3RzLm90cnMub3JnL21haWxtYW4vbGlzdGlu Zm8vZGV2Cg==