Re: Wrong database collation / utf8mb4 encoding for emoticons in subject line
OTRS-Administration <[email protected]> Wed, 20 Jun 2018 13:12:07 +0200
| Newsgroups | gmane.comp.otrs.devel |
|---|---|
| Message-ID | <[email protected]> |
SGkgTWljaGllbCwgZGVhciBsaXN0Cgp0aGFuayB5b3UgZm9yIHlvdXIgcXVpY2sgYW5zd2VyLiBT byBpIGNoYW5nZWQgdGhlIGVuY29kaW5nIGluIAo8L2V0Yy9teXNxbC9teS5jbmY+IHRvIHV0Zjgg YW5kIGFmdGVyIGEgcmVzdGFydCBvZiB0aGUgTXlTUUwtREIgdGhlIAppbnN0YWxsZXIgZW5jb3Vu dGVyZWQgbm8gcHJvYmxlbSBhbnkgbW9yZS4gSSBob3BlIHRoaXMgc2V0dGluZyB3aWxsIHdvcmsg Cm91dCB0aGUgY2FzZSB0aGF0IGVtYWlsIHdpdGggZW1vamlzIHdpbGwgZW50ZXIgdGhlIG5ld2x5 IHNldHVwIE9SVFMgc3lzdGVtLgoKQ2FuIHlvdSBwbGVhc2UgcmVmZXIgdG8gYSBwcm9wZXIgaG93 dG8ganVzdCBpbiBjYXNlIHRoZSBuZXdseSBzZXR1cCBPVFJTIApzeXN0ZW0gY2FuJ3QgaGFuZGxl IHRoZSBpbmNvbWluZyBlbW90aWNvbnMgaW4gc3ViamVjdCBsaW5lPwoKQmVzdCByZWdhcmRzLAoK TWFya3VzCgoKCk9uIDA2LzIwLzIwMTggMTE6NTggQU0sIE1pY2hpZWwgQmVpamVuIHdyb3RlOgo+ IEhpLAo+Cj4gdXRmOG1iNCBpcyB0aGUgb25seSBjaGFyYWN0ZXIgc2V0IHdoaWNoIGNhbiBjb250 YWluIGFsbCBVVEY4Cj4gY2hhcmFjdGVycywgZXNwZWNpYWxseSA0LWJ5dGUgY2hhcmFjdGVycyBz dWNoIGFzIGVtb2ppcyBjYW4ndCBiZQo+IHN0b3JlZCBpbiAndXRmOCcuIFNlZQo+IGh0dHBzOi8v bWVkaXVtLmNvbS9AYWRhbWhvb3Blci9pbi1teXNxbC1uZXZlci11c2UtdXRmOC11c2UtdXRmOG1i NC0xMTc2MTI0M2U0MzQKPgo+IFNvIGl0IHNlZW1zIGxpa2UgdGhpcyBzaG91bGQgYmUgdGhlIGNv bGxhdGlvbiB0byB1c2UgaW4gT1RSUy4KPiBIb3dldmVyIHRoZXJlIGlzIG9uZSBpbmRleCB3aGlj aCBpcyB0b28gbGFyZ2UgZm9yIHVzZSBvbiB1dGY4bWI0Cj4gY29sbGF0aW9uLCB3aGljaCBpcyB3 aHkgT1RSUyBkZXZlbG9wZXJzIGNob3NlIGZvciBub3cgdG8gc3RpY2sgd2l0aAo+IHV0ZjguIFNl ZSB0aGlzIGJ1ZyByZXBvcnQ6IGh0dHBzOi8vYnVncy5vdHJzLm9yZy9zaG93X2J1Zy5jZ2k/aWQ9 MTIzNjEKPgo+Cj4gb2YgY291cnNlLCB5b3UgY291bGQgYWxzbyBqdXN0IGRyb3AgdGhpcyBpbmRl eCAocHJvYmFibHksIHlvdSB3b24ndAo+IG5lZWQgaXQgOkQpIGFuZCB1c2UgdXRmOG1iNC4gTW9z dCBwcm9iYWJseSwgeW91J2xsIGJlIGZpbmUuLi4KPgo+IC0tCj4gTWljaGllbAo+Cj4gT24gV2Vk LCBKdW4gMjAsIDIwMTggYXQgMTA6NTkgQU0sIE9UUlMtQWRtaW5pc3RyYXRpb24KPiA8b3Rycy1h ZG1pbi5raW1AdW5pLWtvbnN0YW56LmRlPiB3cm90ZToKPj4gRGVhciBsaXN0IG1lbWJlcnMKPj4K Pj4gd2UndmUgcmVjZW50bHkgaW5zdGFsbGVkIE9UUlMgdmVyc2lvbiA2LjAuOCAoQ29tbXVuaXR5 IEVkaXRpb24pIG9uIGEgRGViaWFuCj4+IExpbnV4IHN5c3RlbTkuNCB3aXRoIE15U1FMLS9NYXJp YS1EQiAxNS4xIGFuZCBBcGFjaGUgV2Vic2VydmVyIDIuNC4yNSBhcwo+PiB3ZWxsIGFzICBQZXJs IDUsIHZlcnNpb24gMjQuIFRoZSBpbnN0YWxsYXRpb24gcHJvY2VzcyB3ZW50IGZpbmUgdW50aWwg d2UKPj4gcmVhY2hlZCB0aGUgcG9pbnQgdG8gaW5pdGlhbGl6ZSBPVFJTJyBkYXRhYmFzZSB3aXRo IENHSS1Ta3JpcHQgaW5zdGFsbGVyLnBsLgo+PiBUaGUgaW5zdGFsbGVyIHJlcG9ydHM6Cj4+Cj4+ ICJXcm9uZyBkYXRhYmFzZSBjb2xsYXRpb24gKGNoYXJhY3Rlcl9zZXRfZGF0YWJhc2UgaXMgdXRm OG1iNCwgYnV0IGl0IG5lZWRzCj4+IHRvIGJlIHV0ZjgpLiIKPj4KPj4gVGhlIGRlZmF1bHQgY2hh cmFjdGVyIGVuY29kaW5nIG9uIE15U1FMLS9NYXJpYS1EQiBpczoKPj4KPj4gTWFyaWFEQiBbKG5v bmUpXT4gU0hPVyBWQVJJQUJMRVMgV0hFUkUgVmFyaWFibGVfbmFtZSBMSUtFCj4+ICdjaGFyYWN0 ZXJcX3NldFxfJScgT1IgVmFyaWFibGVfbmFtZSBMSUtFICclY29sbGF0aW9uJSc7Cj4+Cj4+ICst LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLSsKPj4gfCBWYXJp YWJsZV9uYW1lICAgICAgICAgICAgfCBWYWx1ZSAgICAgICAgICAgICAgfAo+PiArLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0rCj4+IHwgY2hhcmFjdGVyX3Nl dF9jbGllbnQgICAgIHwgdXRmOG1iNCAgICAgICAgICAgIHwKPj4gfCBjaGFyYWN0ZXJfc2V0X2Nv bm5lY3Rpb24gfCB1dGY4bWI0ICAgICAgICAgICAgfAo+PiB8IGNoYXJhY3Rlcl9zZXRfZGF0YWJh c2UgICB8IHV0ZjhtYjQgICAgICAgICAgICB8Cj4+IHwgY2hhcmFjdGVyX3NldF9maWxlc3lzdGVt IHwgYmluYXJ5ICAgICAgICAgICAgIHwKPj4gfCBjaGFyYWN0ZXJfc2V0X3Jlc3VsdHMgICAgfCB1 dGY4bWI0ICAgICAgICAgICAgfAo+PiB8IGNoYXJhY3Rlcl9zZXRfc2VydmVyICAgICB8IHV0Zjht YjQgICAgICAgICAgICB8Cj4+IHwgY2hhcmFjdGVyX3NldF9zeXN0ZW0gICAgIHwgdXRmOCAgICAg ICAgICAgICAgIHwKPj4gfCBjb2xsYXRpb25fY29ubmVjdGlvbiAgICAgfCB1dGY4bWI0X2dlbmVy YWxfY2kgfAo+PiB8IGNvbGxhdGlvbl9kYXRhYmFzZSAgICAgICB8IHV0ZjhtYjRfZ2VuZXJhbF9j aSB8Cj4+IHwgY29sbGF0aW9uX3NlcnZlciAgICAgICAgIHwgdXRmOG1iNF9nZW5lcmFsX2NpIHwK Pj4gKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tKwo+Pgo+ PiBEbyB3ZSBnZXQgcmlkIG9mIHRoaXMgZXJyb3IgYnkgc2V0dGluZyBjaGFyYWN0ZXJfc2V0X2Rh dGFiYXNlIHRvIHV0Zjggb25seT8KPj4KPj4gSW4gdGhlIHBhc3Qgd2UgZW5jb3VudGVyZWQgcHJv YmxlbXMgd2l0aCBuZXcgZS1tYWlsIHRoYXQgY29tZXMgaW50byB0aGUgT1RSUwo+PiB0aWNrZXQg c3lzdGVtIGFuZCBjb250YWlucyBuYXN0eSBlbW90aWNvbnMgaW4gdGhlIHN1YmplY3QgbGluZTog YXMgYSByZXN1bHQKPj4gdGhlIE9UUlMgc3lzdGVtIHJlZnVzZXMgdG8gaW1wb3J0IGFueSBlbWFp bCBhbnltb3JlLiBTbyB3ZSBkbyB0aGluayBpdCBpcwo+PiB1c2VmdWwgdG8ga2VlcCB0aGUgdXRm OG1iNCBlbmNvZGluZyBpbiB0aGUgZGF0YWJhc2UgYmVjYXVzZSB3aXRoIHRoaXMKPj4gZW5jb2Rp bmcgdGhlIGRhdGFiYXNlIGlzIGNhcGFibGUgdG8gaGFuZGxlIHRoZSBpbmNvbWluZyBlbW90aWNv bnMgaW4gc3ViamVjdAo+PiBsaW5lLgo+Pgo+PiBCZXN0IHJlZ2FyZHMsCj4+Cj4+IE1hcmt1cwo+ Pgo+Pgo+PiAtLQo+PiBPVFJTLUFkbWluaXN0cmF0aW9uCj4+IFVuaXZlcnNpdMOkdCBLb25zdGFu ego+PiBLb21tdW5pa2F0aW9ucy0sIEluZm9ybWF0aW9ucy0sIE1lZGllbnplbnRydW0gKEtJTSkK Pj4gQWJ0ZWlsdW5nZW4gS0lNLUJhc2lzZGllbnN0ZSwgS0lNLVN1cHBvcnQKPj4gNzg0NTcgS29u c3RhbnosIERldXRzY2hsYW5kCj4+Cj4+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fCj4+IE9UUlMgbWFpbGluZyBsaXN0OiBkZXYgLSBXZWJwYWdlOiBodHRw Oi8vb3Rycy5vcmcvCj4+IEFyY2hpdmU6IGh0dHA6Ly9saXN0cy5vdHJzLm9yZy9waXBlcm1haWwv ZGV2Cj4+IFRvIHVuc3Vic2NyaWJlOiBodHRwOi8vbGlzdHMub3Rycy5vcmcvbWFpbG1hbi9saXN0 aW5mby9kZXYKPiBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f Xwo+IE9UUlMgbWFpbGluZyBsaXN0OiBkZXYgLSBXZWJwYWdlOiBodHRwOi8vb3Rycy5vcmcvCj4g QXJjaGl2ZTogaHR0cDovL2xpc3RzLm90cnMub3JnL3BpcGVybWFpbC9kZXYKPiBUbyB1bnN1YnNj cmliZTogaHR0cDovL2xpc3RzLm90cnMub3JnL21haWxtYW4vbGlzdGluZm8vZGV2CgotLSAKT1RS Uy1BZG1pbmlzdHJhdGlvbgpVbml2ZXJzaXTDpHQgS29uc3RhbnoKS29tbXVuaWthdGlvbnMtLCBJ bmZvcm1hdGlvbnMtLCBNZWRpZW56ZW50cnVtIChLSU0pCkFidGVpbHVuZ2VuIEtJTS1CYXNpc2Rp ZW5zdGUsIEtJTS1TdXBwb3J0Cjc4NDU3IEtvbnN0YW56LCBEZXV0c2NobGFuZAoKX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KT1RSUyBtYWlsaW5nIGxpc3Q6 IGRldiAtIFdlYnBhZ2U6IGh0dHA6Ly9vdHJzLm9yZy8KQXJjaGl2ZTogaHR0cDovL2xpc3RzLm90 cnMub3JnL3BpcGVybWFpbC9kZXYKVG8gdW5zdWJzY3JpYmU6IGh0dHA6Ly9saXN0cy5vdHJzLm9y Zy9tYWlsbWFuL2xpc3RpbmZvL2Rldgo=