Re: Wrong database collation / utf8mb4 encoding for emoticons in subject line
Martin Gruner <[email protected]> Wed, 20 Jun 2018 12:00:42 +0200
| Newsgroups | gmane.comp.otrs.devel |
|---|---|
| Message-ID | <[email protected]> |
SGVsbG8gTWFya3VzLAoKaGVyZSBpcyBzb21lIGJhY2tncm91bmQgaW5mb3JtYXRpb24gb24gd2h5 IHdlIHdlcmVu4oCZdCBhYmxlIHRvIHJlY29tbWVuZCB1dGY4bWI0IHVudGlsIG5vdzoKaHR0cHM6 Ly9idWdzLm90cnMub3JnL3Nob3dfYnVnLmNnaT9pZD0xMjM2MQoKQmVzdCByZWdhcmRzLAoKTWFy dGluIEdydW5lcgpUZWFtIExlYWQgUiZECgpPVFJTIEFHCkJhaG5ob2ZwbGF0eiAxYQo5NDMxNSBT dHJhdWJpbmcKClQ6ICs0OSAoMCk2MTcyIDY4MTk4OCAwCkY6ICs0OSAoMCk5NDIxIDU2ODE4IDE4 Ckk6ICBodHRwczovL3d3dy5vdHJzLmNvbS8KCkdlc2Now6RmdHNzaXR6OiBCYWQgSG9tYnVyZywg QW10c2dlcmljaHQ6IEJhZCBIb21idXJnLCBIUkIgMTA3NTEsIFVTdC1Oci46IERFMjU2NjEwMDY1 CkF1ZnNpY2h0c3JhdHN2b3JzaXR6ZW5kZXI6IEJ1cmNoYXJkIFN0ZWluYmlsZCwgVm9yc3RhbmQ6 IEFuZHLDqSBNaW5kZXJtYW5uIChWb3JzaXR6ZW5kZXIpLCBDaHJpc3RvcGhlciBLdWhuLCBTYWJp bmUgUmllZGVsCgpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fCgpDdXN0b21lciBTZXJ2aWNlLCBJVFNNIG9kZXIgQ29ycG9yYXRlIFNlY3VyaXR5IOKA kyBPVFJTIGhhdCBkaWUgcGFzc2VuZGUgTMO2c3VuZy4KRXJmYWhyZW4gU2llIG1laHI6IGh0dHBz Oi8vb3Rycy5jb20vZGUvb3Rycy1sb2VzdW5nZW4vCgo+IEFtIDIwLjA2LjIwMTggdW0gMTA6NTkg c2NocmllYiBPVFJTLUFkbWluaXN0cmF0aW9uIDxvdHJzLWFkbWluLmtpbUB1bmkta29uc3Rhbnou ZGU+Ogo+IAo+IERlYXIgbGlzdCBtZW1iZXJzCj4gCj4gd2UndmUgcmVjZW50bHkgaW5zdGFsbGVk IE9UUlMgdmVyc2lvbiA2LjAuOCAoQ29tbXVuaXR5IEVkaXRpb24pIG9uIGEgRGViaWFuIExpbnV4 IHN5c3RlbTkuNCB3aXRoIE15U1FMLS9NYXJpYS1EQiAxNS4xIGFuZCBBcGFjaGUgV2Vic2VydmVy IDIuNC4yNSBhcyB3ZWxsIGFzICBQZXJsIDUsIHZlcnNpb24gMjQuIFRoZSBpbnN0YWxsYXRpb24g cHJvY2VzcyB3ZW50IGZpbmUgdW50aWwgd2UgcmVhY2hlZCB0aGUgcG9pbnQgdG8gaW5pdGlhbGl6 ZSBPVFJTJyBkYXRhYmFzZSB3aXRoIENHSS1Ta3JpcHQgaW5zdGFsbGVyLnBsLiBUaGUgaW5zdGFs bGVyIHJlcG9ydHM6Cj4gCj4gIldyb25nIGRhdGFiYXNlIGNvbGxhdGlvbiAoY2hhcmFjdGVyX3Nl dF9kYXRhYmFzZSBpcyB1dGY4bWI0LCBidXQgaXQgbmVlZHMgdG8gYmUgdXRmOCkuIgo+IAo+IFRo ZSBkZWZhdWx0IGNoYXJhY3RlciBlbmNvZGluZyBvbiBNeVNRTC0vTWFyaWEtREIgaXM6Cj4gCj4g TWFyaWFEQiBbKG5vbmUpXT4gU0hPVyBWQVJJQUJMRVMgV0hFUkUgVmFyaWFibGVfbmFtZSBMSUtF ICdjaGFyYWN0ZXJcX3NldFxfJScgT1IgVmFyaWFibGVfbmFtZSBMSUtFICclY29sbGF0aW9uJSc7 Cj4gCj4gKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tKwo+ IHwgVmFyaWFibGVfbmFtZSAgICAgICAgICAgIHwgVmFsdWUgICAgICAgICAgICAgIHwKPiArLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0rCj4gfCBjaGFyYWN0 ZXJfc2V0X2NsaWVudCAgICAgfCB1dGY4bWI0ICAgICAgICAgICAgfAo+IHwgY2hhcmFjdGVyX3Nl dF9jb25uZWN0aW9uIHwgdXRmOG1iNCAgICAgICAgICAgIHwKPiB8IGNoYXJhY3Rlcl9zZXRfZGF0 YWJhc2UgICB8IHV0ZjhtYjQgICAgICAgICAgICB8Cj4gfCBjaGFyYWN0ZXJfc2V0X2ZpbGVzeXN0 ZW0gfCBiaW5hcnkgICAgICAgICAgICAgfAo+IHwgY2hhcmFjdGVyX3NldF9yZXN1bHRzICAgIHwg dXRmOG1iNCAgICAgICAgICAgIHwKPiB8IGNoYXJhY3Rlcl9zZXRfc2VydmVyICAgICB8IHV0Zjht YjQgICAgICAgICAgICB8Cj4gfCBjaGFyYWN0ZXJfc2V0X3N5c3RlbSAgICAgfCB1dGY4ICAgICAg ICAgICAgICAgfAo+IHwgY29sbGF0aW9uX2Nvbm5lY3Rpb24gICAgIHwgdXRmOG1iNF9nZW5lcmFs X2NpIHwKPiB8IGNvbGxhdGlvbl9kYXRhYmFzZSAgICAgICB8IHV0ZjhtYjRfZ2VuZXJhbF9jaSB8 Cj4gfCBjb2xsYXRpb25fc2VydmVyICAgICAgICAgfCB1dGY4bWI0X2dlbmVyYWxfY2kgfAo+ICst LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLSsKPiAKPiBEbyB3 ZSBnZXQgcmlkIG9mIHRoaXMgZXJyb3IgYnkgc2V0dGluZyBjaGFyYWN0ZXJfc2V0X2RhdGFiYXNl IHRvIHV0Zjggb25seT8KPiAKPiBJbiB0aGUgcGFzdCB3ZSBlbmNvdW50ZXJlZCBwcm9ibGVtcyB3 aXRoIG5ldyBlLW1haWwgdGhhdCBjb21lcyBpbnRvIHRoZSBPVFJTIHRpY2tldCBzeXN0ZW0gYW5k IGNvbnRhaW5zIG5hc3R5IGVtb3RpY29ucyBpbiB0aGUgc3ViamVjdCBsaW5lOiBhcyBhIHJlc3Vs dCB0aGUgT1RSUyBzeXN0ZW0gcmVmdXNlcyB0byBpbXBvcnQgYW55IGVtYWlsIGFueW1vcmUuIFNv IHdlIGRvIHRoaW5rIGl0IGlzIHVzZWZ1bCB0byBrZWVwIHRoZSB1dGY4bWI0IGVuY29kaW5nIGlu IHRoZSBkYXRhYmFzZSBiZWNhdXNlIHdpdGggdGhpcyBlbmNvZGluZyB0aGUgZGF0YWJhc2UgaXMg Y2FwYWJsZSB0byBoYW5kbGUgdGhlIGluY29taW5nIGVtb3RpY29ucyBpbiBzdWJqZWN0IGxpbmUu Cj4gCj4gQmVzdCByZWdhcmRzLAo+IAo+IE1hcmt1cwo+IAo+IAo+IC0tIAo+IE9UUlMtQWRtaW5p c3RyYXRpb24KPiBVbml2ZXJzaXTDpHQgS29uc3RhbnoKPiBLb21tdW5pa2F0aW9ucy0sIEluZm9y bWF0aW9ucy0sIE1lZGllbnplbnRydW0gKEtJTSkKPiBBYnRlaWx1bmdlbiBLSU0tQmFzaXNkaWVu c3RlLCBLSU0tU3VwcG9ydAo+IDc4NDU3IEtvbnN0YW56LCBEZXV0c2NobGFuZAo+IAo+IF9fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCj4gT1RSUyBtYWlsaW5n IGxpc3Q6IGRldiAtIFdlYnBhZ2U6IGh0dHA6Ly9vdHJzLm9yZy8KPiBBcmNoaXZlOiBodHRwOi8v bGlzdHMub3Rycy5vcmcvcGlwZXJtYWlsL2Rldgo+IFRvIHVuc3Vic2NyaWJlOiBodHRwOi8vbGlz dHMub3Rycy5vcmcvbWFpbG1hbi9saXN0aW5mby9kZXYKCl9fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fCk9UUlMgbWFpbGluZyBsaXN0OiBkZXYgLSBXZWJwYWdl OiBodHRwOi8vb3Rycy5vcmcvCkFyY2hpdmU6IGh0dHA6Ly9saXN0cy5vdHJzLm9yZy9waXBlcm1h aWwvZGV2ClRvIHVuc3Vic2NyaWJlOiBodHRwOi8vbGlzdHMub3Rycy5vcmcvbWFpbG1hbi9saXN0 aW5mby9kZXYK