Re: Wrong database collation / utf8mb4 encoding for emoticons in subject line
Martin Gruner <[email protected]> Wed, 20 Jun 2018 16:00:53 +0200
| Newsgroups | gmane.comp.otrs.devel |
|---|---|
| Message-ID | <[email protected]> |
SGVsbG8gTWFya3VzLAoKdGhlIGVtYWlscyBjYW4gYmUgc3RvcmVkLCBidXQgYW55IGNoYXJhY3Rl cnMgdGhhdCBjYW5ub3QgYmUgcmVwcmVzZW50ZWQgYnkgYSAzLWJ5dGUgVW5pY29kZSBzZXF1ZW5j ZSB3aWxsIGJlIHJlcGxhY2VkIHdpdGggdGhlIMK7VW5rbm93biBDaGFyYWN0ZXLCqyBVbmljb2Rl IHN5bWJvbCAo77+9KSBieSBvdXIgTXlTUUwgYmFja2VuZC4KCkJlc3QgcmVnYXJkcywKCk1hcnRp biBHcnVuZXIKVGVhbSBMZWFkIFImRAoKT1RSUyBBRwpCYWhuaG9mcGxhdHogMWEKOTQzMTUgU3Ry YXViaW5nCgpUOiArNDkgKDApNjE3MiA2ODE5ODggMApGOiArNDkgKDApOTQyMSA1NjgxOCAxOApJ OiAgaHR0cHM6Ly93d3cub3Rycy5jb20vCgpHZXNjaMOkZnRzc2l0ejogQmFkIEhvbWJ1cmcsIEFt dHNnZXJpY2h0OiBCYWQgSG9tYnVyZywgSFJCIDEwNzUxLCBVU3QtTnIuOiBERTI1NjYxMDA2NQpB dWZzaWNodHNyYXRzdm9yc2l0emVuZGVyOiBCdXJjaGFyZCBTdGVpbmJpbGQsIFZvcnN0YW5kOiBB bmRyw6kgTWluZGVybWFubiAoVm9yc2l0emVuZGVyKSwgQ2hyaXN0b3BoZXIgS3VobiwgU2FiaW5l IFJpZWRlbAoKX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fXwoKQ3VzdG9tZXIgU2VydmljZSwgSVRTTSBvZGVyIENvcnBvcmF0ZSBTZWN1cml0eSDigJMg T1RSUyBoYXQgZGllIHBhc3NlbmRlIEzDtnN1bmcuCkVyZmFocmVuIFNpZSBtZWhyOiBodHRwczov L290cnMuY29tL2RlL290cnMtbG9lc3VuZ2VuLwoKPiBBbSAyMC4wNi4yMDE4IHVtIDEzOjEyIHNj aHJpZWIgT1RSUy1BZG1pbmlzdHJhdGlvbiA8b3Rycy1hZG1pbi5raW1AdW5pLWtvbnN0YW56LmRl PjoKPiAKPiBIaSBNaWNoaWVsLCBkZWFyIGxpc3QKPiAKPiB0aGFuayB5b3UgZm9yIHlvdXIgcXVp Y2sgYW5zd2VyLiBTbyBpIGNoYW5nZWQgdGhlIGVuY29kaW5nIGluIDwvZXRjL215c3FsL215LmNu Zj4gdG8gdXRmOCBhbmQgYWZ0ZXIgYSByZXN0YXJ0IG9mIHRoZSBNeVNRTC1EQiB0aGUgaW5zdGFs bGVyIGVuY291bnRlcmVkIG5vIHByb2JsZW0gYW55IG1vcmUuIEkgaG9wZSB0aGlzIHNldHRpbmcg d2lsbCB3b3JrIG91dCB0aGUgY2FzZSB0aGF0IGVtYWlsIHdpdGggZW1vamlzIHdpbGwgZW50ZXIg dGhlIG5ld2x5IHNldHVwIE9SVFMgc3lzdGVtLgo+IAo+IENhbiB5b3UgcGxlYXNlIHJlZmVyIHRv IGEgcHJvcGVyIGhvd3RvIGp1c3QgaW4gY2FzZSB0aGUgbmV3bHkgc2V0dXAgT1RSUyBzeXN0ZW0g Y2FuJ3QgaGFuZGxlIHRoZSBpbmNvbWluZyBlbW90aWNvbnMgaW4gc3ViamVjdCBsaW5lPwo+IAo+ IEJlc3QgcmVnYXJkcywKPiAKPiBNYXJrdXMKPiAKPiAKPiAKPiBPbiAwNi8yMC8yMDE4IDExOjU4 IEFNLCBNaWNoaWVsIEJlaWplbiB3cm90ZToKPj4gSGksCj4+IAo+PiB1dGY4bWI0IGlzIHRoZSBv bmx5IGNoYXJhY3RlciBzZXQgd2hpY2ggY2FuIGNvbnRhaW4gYWxsIFVURjgKPj4gY2hhcmFjdGVy cywgZXNwZWNpYWxseSA0LWJ5dGUgY2hhcmFjdGVycyBzdWNoIGFzIGVtb2ppcyBjYW4ndCBiZQo+ PiBzdG9yZWQgaW4gJ3V0ZjgnLiBTZWUKPj4gaHR0cHM6Ly9tZWRpdW0uY29tL0BhZGFtaG9vcGVy L2luLW15c3FsLW5ldmVyLXVzZS11dGY4LXVzZS11dGY4bWI0LTExNzYxMjQzZTQzNAo+PiAKPj4g U28gaXQgc2VlbXMgbGlrZSB0aGlzIHNob3VsZCBiZSB0aGUgY29sbGF0aW9uIHRvIHVzZSBpbiBP VFJTLgo+PiBIb3dldmVyIHRoZXJlIGlzIG9uZSBpbmRleCB3aGljaCBpcyB0b28gbGFyZ2UgZm9y IHVzZSBvbiB1dGY4bWI0Cj4+IGNvbGxhdGlvbiwgd2hpY2ggaXMgd2h5IE9UUlMgZGV2ZWxvcGVy cyBjaG9zZSBmb3Igbm93IHRvIHN0aWNrIHdpdGgKPj4gdXRmOC4gU2VlIHRoaXMgYnVnIHJlcG9y dDogaHR0cHM6Ly9idWdzLm90cnMub3JnL3Nob3dfYnVnLmNnaT9pZD0xMjM2MQo+PiAKPj4gCj4+ IG9mIGNvdXJzZSwgeW91IGNvdWxkIGFsc28ganVzdCBkcm9wIHRoaXMgaW5kZXggKHByb2JhYmx5 LCB5b3Ugd29uJ3QKPj4gbmVlZCBpdCA6RCkgYW5kIHVzZSB1dGY4bWI0LiBNb3N0IHByb2JhYmx5 LCB5b3UnbGwgYmUgZmluZS4uLgo+PiAKPj4gLS0KPj4gTWljaGllbAo+PiAKPj4gT24gV2VkLCBK dW4gMjAsIDIwMTggYXQgMTA6NTkgQU0sIE9UUlMtQWRtaW5pc3RyYXRpb24KPj4gPG90cnMtYWRt aW4ua2ltQHVuaS1rb25zdGFuei5kZT4gd3JvdGU6Cj4+PiBEZWFyIGxpc3QgbWVtYmVycwo+Pj4g Cj4+PiB3ZSd2ZSByZWNlbnRseSBpbnN0YWxsZWQgT1RSUyB2ZXJzaW9uIDYuMC44IChDb21tdW5p dHkgRWRpdGlvbikgb24gYSBEZWJpYW4KPj4+IExpbnV4IHN5c3RlbTkuNCB3aXRoIE15U1FMLS9N YXJpYS1EQiAxNS4xIGFuZCBBcGFjaGUgV2Vic2VydmVyIDIuNC4yNSBhcwo+Pj4gd2VsbCBhcyAg UGVybCA1LCB2ZXJzaW9uIDI0LiBUaGUgaW5zdGFsbGF0aW9uIHByb2Nlc3Mgd2VudCBmaW5lIHVu dGlsIHdlCj4+PiByZWFjaGVkIHRoZSBwb2ludCB0byBpbml0aWFsaXplIE9UUlMnIGRhdGFiYXNl IHdpdGggQ0dJLVNrcmlwdCBpbnN0YWxsZXIucGwuCj4+PiBUaGUgaW5zdGFsbGVyIHJlcG9ydHM6 Cj4+PiAKPj4+ICJXcm9uZyBkYXRhYmFzZSBjb2xsYXRpb24gKGNoYXJhY3Rlcl9zZXRfZGF0YWJh c2UgaXMgdXRmOG1iNCwgYnV0IGl0IG5lZWRzCj4+PiB0byBiZSB1dGY4KS4iCj4+PiAKPj4+IFRo ZSBkZWZhdWx0IGNoYXJhY3RlciBlbmNvZGluZyBvbiBNeVNRTC0vTWFyaWEtREIgaXM6Cj4+PiAK Pj4+IE1hcmlhREIgWyhub25lKV0+IFNIT1cgVkFSSUFCTEVTIFdIRVJFIFZhcmlhYmxlX25hbWUg TElLRQo+Pj4gJ2NoYXJhY3Rlclxfc2V0XF8lJyBPUiBWYXJpYWJsZV9uYW1lIExJS0UgJyVjb2xs YXRpb24lJzsKPj4+IAo+Pj4gKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0t LS0tLS0tLS0tKwo+Pj4gfCBWYXJpYWJsZV9uYW1lICAgICAgICAgICAgfCBWYWx1ZSAgICAgICAg ICAgICAgfAo+Pj4gKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0t LS0tKwo+Pj4gfCBjaGFyYWN0ZXJfc2V0X2NsaWVudCAgICAgfCB1dGY4bWI0ICAgICAgICAgICAg fAo+Pj4gfCBjaGFyYWN0ZXJfc2V0X2Nvbm5lY3Rpb24gfCB1dGY4bWI0ICAgICAgICAgICAgfAo+ Pj4gfCBjaGFyYWN0ZXJfc2V0X2RhdGFiYXNlICAgfCB1dGY4bWI0ICAgICAgICAgICAgfAo+Pj4g fCBjaGFyYWN0ZXJfc2V0X2ZpbGVzeXN0ZW0gfCBiaW5hcnkgICAgICAgICAgICAgfAo+Pj4gfCBj aGFyYWN0ZXJfc2V0X3Jlc3VsdHMgICAgfCB1dGY4bWI0ICAgICAgICAgICAgfAo+Pj4gfCBjaGFy YWN0ZXJfc2V0X3NlcnZlciAgICAgfCB1dGY4bWI0ICAgICAgICAgICAgfAo+Pj4gfCBjaGFyYWN0 ZXJfc2V0X3N5c3RlbSAgICAgfCB1dGY4ICAgICAgICAgICAgICAgfAo+Pj4gfCBjb2xsYXRpb25f Y29ubmVjdGlvbiAgICAgfCB1dGY4bWI0X2dlbmVyYWxfY2kgfAo+Pj4gfCBjb2xsYXRpb25fZGF0 YWJhc2UgICAgICAgfCB1dGY4bWI0X2dlbmVyYWxfY2kgfAo+Pj4gfCBjb2xsYXRpb25fc2VydmVy ICAgICAgICAgfCB1dGY4bWI0X2dlbmVyYWxfY2kgfAo+Pj4gKy0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tKwo+Pj4gCj4+PiBEbyB3ZSBnZXQgcmlkIG9mIHRo aXMgZXJyb3IgYnkgc2V0dGluZyBjaGFyYWN0ZXJfc2V0X2RhdGFiYXNlIHRvIHV0Zjggb25seT8K Pj4+IAo+Pj4gSW4gdGhlIHBhc3Qgd2UgZW5jb3VudGVyZWQgcHJvYmxlbXMgd2l0aCBuZXcgZS1t YWlsIHRoYXQgY29tZXMgaW50byB0aGUgT1RSUwo+Pj4gdGlja2V0IHN5c3RlbSBhbmQgY29udGFp bnMgbmFzdHkgZW1vdGljb25zIGluIHRoZSBzdWJqZWN0IGxpbmU6IGFzIGEgcmVzdWx0Cj4+PiB0 aGUgT1RSUyBzeXN0ZW0gcmVmdXNlcyB0byBpbXBvcnQgYW55IGVtYWlsIGFueW1vcmUuIFNvIHdl IGRvIHRoaW5rIGl0IGlzCj4+PiB1c2VmdWwgdG8ga2VlcCB0aGUgdXRmOG1iNCBlbmNvZGluZyBp biB0aGUgZGF0YWJhc2UgYmVjYXVzZSB3aXRoIHRoaXMKPj4+IGVuY29kaW5nIHRoZSBkYXRhYmFz ZSBpcyBjYXBhYmxlIHRvIGhhbmRsZSB0aGUgaW5jb21pbmcgZW1vdGljb25zIGluIHN1YmplY3QK Pj4+IGxpbmUuCj4+PiAKPj4+IEJlc3QgcmVnYXJkcywKPj4+IAo+Pj4gTWFya3VzCj4+PiAKPj4+ IAo+Pj4gLS0KPj4+IE9UUlMtQWRtaW5pc3RyYXRpb24KPj4+IFVuaXZlcnNpdMOkdCBLb25zdGFu ego+Pj4gS29tbXVuaWthdGlvbnMtLCBJbmZvcm1hdGlvbnMtLCBNZWRpZW56ZW50cnVtIChLSU0p Cj4+PiBBYnRlaWx1bmdlbiBLSU0tQmFzaXNkaWVuc3RlLCBLSU0tU3VwcG9ydAo+Pj4gNzg0NTcg S29uc3RhbnosIERldXRzY2hsYW5kCj4+PiAKPj4+IF9fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fCj4+PiBPVFJTIG1haWxpbmcgbGlzdDogZGV2IC0gV2VicGFn ZTogaHR0cDovL290cnMub3JnLwo+Pj4gQXJjaGl2ZTogaHR0cDovL2xpc3RzLm90cnMub3JnL3Bp cGVybWFpbC9kZXYKPj4+IFRvIHVuc3Vic2NyaWJlOiBodHRwOi8vbGlzdHMub3Rycy5vcmcvbWFp bG1hbi9saXN0aW5mby9kZXYKPj4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX18KPj4gT1RSUyBtYWlsaW5nIGxpc3Q6IGRldiAtIFdlYnBhZ2U6IGh0dHA6Ly9v dHJzLm9yZy8KPj4gQXJjaGl2ZTogaHR0cDovL2xpc3RzLm90cnMub3JnL3BpcGVybWFpbC9kZXYK Pj4gVG8gdW5zdWJzY3JpYmU6IGh0dHA6Ly9saXN0cy5vdHJzLm9yZy9tYWlsbWFuL2xpc3RpbmZv L2Rldgo+IAo+IC0tIAo+IE9UUlMtQWRtaW5pc3RyYXRpb24KPiBVbml2ZXJzaXTDpHQgS29uc3Rh bnoKPiBLb21tdW5pa2F0aW9ucy0sIEluZm9ybWF0aW9ucy0sIE1lZGllbnplbnRydW0gKEtJTSkK PiBBYnRlaWx1bmdlbiBLSU0tQmFzaXNkaWVuc3RlLCBLSU0tU3VwcG9ydAo+IDc4NDU3IEtvbnN0 YW56LCBEZXV0c2NobGFuZAo+IAo+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fCj4gT1RSUyBtYWlsaW5nIGxpc3Q6IGRldiAtIFdlYnBhZ2U6IGh0dHA6Ly9v dHJzLm9yZy8KPiBBcmNoaXZlOiBodHRwOi8vbGlzdHMub3Rycy5vcmcvcGlwZXJtYWlsL2Rldgo+ IFRvIHVuc3Vic2NyaWJlOiBodHRwOi8vbGlzdHMub3Rycy5vcmcvbWFpbG1hbi9saXN0aW5mby9k ZXYKCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCk9UUlMg bWFpbGluZyBsaXN0OiBkZXYgLSBXZWJwYWdlOiBodHRwOi8vb3Rycy5vcmcvCkFyY2hpdmU6IGh0 dHA6Ly9saXN0cy5vdHJzLm9yZy9waXBlcm1haWwvZGV2ClRvIHVuc3Vic2NyaWJlOiBodHRwOi8v bGlzdHMub3Rycy5vcmcvbWFpbG1hbi9saXN0aW5mby9kZXYK