Wrong database collation / utf8mb4 encoding for emoticons in subject line
OTRS-Administration <[email protected]> Wed, 20 Jun 2018 10:59:11 +0200
| Newsgroups | gmane.comp.otrs.devel |
|---|---|
| Message-ID | <[email protected]> |
RGVhciBsaXN0IG1lbWJlcnMKCndlJ3ZlIHJlY2VudGx5IGluc3RhbGxlZCBPVFJTIHZlcnNpb24g Ni4wLjggKENvbW11bml0eSBFZGl0aW9uKSBvbiBhIApEZWJpYW4gTGludXggc3lzdGVtOS40IHdp dGggTXlTUUwtL01hcmlhLURCIDE1LjEgYW5kIEFwYWNoZSBXZWJzZXJ2ZXIgCjIuNC4yNSBhcyB3 ZWxsIGFzwqAgUGVybCA1LCB2ZXJzaW9uIDI0LiBUaGUgaW5zdGFsbGF0aW9uIHByb2Nlc3Mgd2Vu dCAKZmluZSB1bnRpbCB3ZSByZWFjaGVkIHRoZSBwb2ludCB0byBpbml0aWFsaXplIE9UUlMnIGRh dGFiYXNlIHdpdGggCkNHSS1Ta3JpcHQgaW5zdGFsbGVyLnBsLiBUaGUgaW5zdGFsbGVyIHJlcG9y dHM6CgoiV3JvbmcgZGF0YWJhc2UgY29sbGF0aW9uIChjaGFyYWN0ZXJfc2V0X2RhdGFiYXNlIGlz IHV0ZjhtYjQsIGJ1dCBpdCAKbmVlZHMgdG8gYmUgdXRmOCkuIgoKVGhlIGRlZmF1bHQgY2hhcmFj dGVyIGVuY29kaW5nIG9uIE15U1FMLS9NYXJpYS1EQiBpczoKCk1hcmlhREIgWyhub25lKV0+IFNI T1cgVkFSSUFCTEVTIFdIRVJFIFZhcmlhYmxlX25hbWUgTElLRSAKJ2NoYXJhY3Rlclxfc2V0XF8l JyBPUiBWYXJpYWJsZV9uYW1lIExJS0UgJyVjb2xsYXRpb24lJzsKCistLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLSsKfCBWYXJpYWJsZV9uYW1lwqDCoMKgwqDC oMKgwqDCoMKgwqDCoCB8IFZhbHVlwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgfAorLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0rCnwgY2hhcmFjdGVyX3Nl dF9jbGllbnTCoMKgwqDCoCB8IHV0ZjhtYjTCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIHwKfCBjaGFy YWN0ZXJfc2V0X2Nvbm5lY3Rpb24gfCB1dGY4bWI0wqDCoMKgwqDCoMKgwqDCoMKgwqDCoCB8Cnwg Y2hhcmFjdGVyX3NldF9kYXRhYmFzZcKgwqAgfCB1dGY4bWI0wqDCoMKgwqDCoMKgwqDCoMKgwqDC oCB8CnwgY2hhcmFjdGVyX3NldF9maWxlc3lzdGVtIHwgYmluYXJ5wqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgIHwKfCBjaGFyYWN0ZXJfc2V0X3Jlc3VsdHPCoMKgwqAgfCB1dGY4bWI0wqDCoMKgwqDC oMKgwqDCoMKgwqDCoCB8CnwgY2hhcmFjdGVyX3NldF9zZXJ2ZXLCoMKgwqDCoCB8IHV0ZjhtYjTC oMKgwqDCoMKgwqDCoMKgwqDCoMKgIHwKfCBjaGFyYWN0ZXJfc2V0X3N5c3RlbcKgwqDCoMKgIHwg dXRmOMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgfAp8IGNvbGxhdGlvbl9jb25uZWN0aW9u wqDCoMKgwqAgfCB1dGY4bWI0X2dlbmVyYWxfY2kgfAp8IGNvbGxhdGlvbl9kYXRhYmFzZcKgwqDC oMKgwqDCoCB8IHV0ZjhtYjRfZ2VuZXJhbF9jaSB8CnwgY29sbGF0aW9uX3NlcnZlcsKgwqDCoMKg wqDCoMKgwqAgfCB1dGY4bWI0X2dlbmVyYWxfY2kgfAorLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0rCgpEbyB3ZSBnZXQgcmlkIG9mIHRoaXMgZXJyb3IgYnkg c2V0dGluZyBjaGFyYWN0ZXJfc2V0X2RhdGFiYXNlIHRvIHV0Zjggb25seT8KCkluIHRoZSBwYXN0 IHdlIGVuY291bnRlcmVkIHByb2JsZW1zIHdpdGggbmV3IGUtbWFpbCB0aGF0IGNvbWVzIGludG8g dGhlIApPVFJTIHRpY2tldCBzeXN0ZW0gYW5kIGNvbnRhaW5zIG5hc3R5IGVtb3RpY29ucyBpbiB0 aGUgc3ViamVjdCBsaW5lOiBhcyAKYSByZXN1bHQgdGhlIE9UUlMgc3lzdGVtIHJlZnVzZXMgdG8g aW1wb3J0IGFueSBlbWFpbCBhbnltb3JlLiBTbyB3ZSBkbyAKdGhpbmsgaXQgaXMgdXNlZnVsIHRv IGtlZXAgdGhlIHV0ZjhtYjQgZW5jb2RpbmcgaW4gdGhlIGRhdGFiYXNlIGJlY2F1c2UgCndpdGgg dGhpcyBlbmNvZGluZyB0aGUgZGF0YWJhc2UgaXMgY2FwYWJsZSB0byBoYW5kbGUgdGhlIGluY29t aW5nIAplbW90aWNvbnMgaW4gc3ViamVjdCBsaW5lLgoKQmVzdCByZWdhcmRzLAoKTWFya3VzCgoK LS0gCk9UUlMtQWRtaW5pc3RyYXRpb24KVW5pdmVyc2l0w6R0IEtvbnN0YW56CktvbW11bmlrYXRp b25zLSwgSW5mb3JtYXRpb25zLSwgTWVkaWVuemVudHJ1bSAoS0lNKQpBYnRlaWx1bmdlbiBLSU0t QmFzaXNkaWVuc3RlLCBLSU0tU3VwcG9ydAo3ODQ1NyBLb25zdGFueiwgRGV1dHNjaGxhbmQKCl9f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCk9UUlMgbWFpbGlu ZyBsaXN0OiBkZXYgLSBXZWJwYWdlOiBodHRwOi8vb3Rycy5vcmcvCkFyY2hpdmU6IGh0dHA6Ly9s aXN0cy5vdHJzLm9yZy9waXBlcm1haWwvZGV2ClRvIHVuc3Vic2NyaWJlOiBodHRwOi8vbGlzdHMu b3Rycy5vcmcvbWFpbG1hbi9saXN0aW5mby9kZXYK