From: Rick James
Date: August 27 2012 5:27pm
Subject: RE: MySQL, UTF8 and collations
List-Archive: http://lists.mysql.com/mysql/228091
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148B888DDF@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

VGhlcmUgaXMgYSBzZWN0aW9uIG9uIEdlcm1hbiBTaGFycC1zIGluIGh0dHA6Ly9teXNxbC5yandl
Yi5vcmcvZG9jLnBocC9jaGFyY29sbA0KSSBhZ3JlZSB3aXRoICJkaXJ0eSIuDQpBcyBJIHVuZGVy
c3RhbmQgaXQsIGFib3V0IDUuMS4yNCwgdGhleSBzYWlkICJPb3BzLCBzaGFycC1zIGlzIGNvbGxh
dGVkIHdyb25nLCBsZXQncyBmaXggaXQiLiAgVGhlIGZpeCBicm9rZSB0aGluZ3MsIGJ1dCB0aGV5
IHN0dWNrIGJ5IHRoZSAiY29ycmVjdCIgc29ydGluZy4gIEV2ZW50dWFsbHkgdGhleSBzYWlkICJP
aCwgbGV0J3MgYWRkIGFub3RoZXIsIGNvbXBhdGlibGUsIGNvbGxhdGlvbiIuDQoNClRoZXkgd2Vy
ZSBjYXVnaHQgYmV0d2VlbiBhIHJvY2sgYW5kIGEgaGFyZCBwbGFjZS4NCg0KPiAtLS0tLU9yaWdp
bmFsIE1lc3NhZ2UtLS0tLQ0KPiBGcm9tOiBKb2hhbiBEZSBNZWVyc21hbiBbbWFpbHRvOnZlZ2l2
YW1wQHR1eGVyYS5iZV0NCj4gU2VudDogTW9uZGF5LCBBdWd1c3QgMjcsIDIwMTIgNzo0MyBBTQ0K
PiBUbzogbXlzcWwNCj4gU3ViamVjdDogTXlTUUwsIFVURjggYW5kIGNvbGxhdGlvbnMNCj4gDQo+
IEhleSwNCj4gDQo+IFdlJ3JlIHVwZ3JhZGluZyBNeVNRTHMgZnJvbSA1LjAgdG8gNS41LCBhbmQg
cnVubmluZyBpbnRvIHRoZQ0KPiBwcmVkaWN0YWJsZSB1dGY4X2dlbmVyYWxfY2kgYnVeV3dlLW1l
YW50LXRvLWRvLXRoYXQgd2l0aCBnZXJtYW4gw58gYW5kDQo+IHNpbWlsYXIgY2hhcmFjdGVycy4g
VGhlIHNlcnZlciBzd2FsbG93ZWQgdGhlIGV4aXN0aW5nIGRhdGFmaWxlcyAodGhhbmsNCj4gZ29k
IGZvciB0aGF0KSBzbyB3ZSdyZSB1cCBhbmQgcnVubmluZywgYnV0ICJjaGVjayB0YWJsZSIgZG9l
cyB3aGluZQ0KPiBhYm91dCBuZWVkaW5nIGEgZnVsbCByZWJ1aWxkLCB3aGljaCBpcyBjbGVhcmx5
IHRoYXQgaXNzdWUuDQo+IA0KPiBOb3csIEknbSBhd2FyZSB0aGF0IHRoaXMgc2hvdWxkIGJlIGZp
eGVkIGJ5IHVzaW5nIHRoZSB1dGY4X3VuaWNvZGVfY2kNCj4gY29sbGF0aW9uOyBidXQgc29tZWhv
dyBpdCBpc24ndC4uLg0KPiANCj4gVGhlIGl0cy1ub3QtYS1idWctYnV0LWhlcmVzLXRoZS1maXgg
Y29sbGF0aW9uIHV0ZjhfZ2VuZXJhbF9teXNxbDUwMF9jaQ0KPiBkb2VzIHdvcmssIGJ1dCBob25l
c3RseSBJIGZlZWwgdGhhdCB0aGF0J3Mga2luZCBvZiBkaXJ0eS4NCj4gDQo+IEFueSBpZGVhcyB3
aHkgdXRmOF91bmljb2RlX2NpIGRvZXNuJ3Qgd29yayBhcyBleHBlY3RlZD8gVGhlIG5ldyBzZXJ2
ZXINCj4gdmVyc2lvbiBpcyA1LjUuMjQtMX5kb3RkZWIuMS1sb2cuDQo+IA0KPiBUaHgsDQo+IEpv
aGFuDQo+IA0KPiANCj4gbXlzcWw+IHNldCBuYW1lcyBVVEY4Ow0KPiBRdWVyeSBPSywgMCByb3dz
IGFmZmVjdGVkICgwLjAwIHNlYykNCj4gDQo+IG15c3FsPiBzaG93IGNyZWF0ZSB0YWJsZSBzZWFy
Y2hfaW5kZXg7DQo+ICstLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQo+IC0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rDQo+IHwgVGFibGUgfCBDcmVhdGUgVGFi
bGUgfA0KPiArLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KPiAtLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LQ0KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLQ0KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKw0KPiB8IHNlYXJjaF9pbmRleCB8IENSRUFURSBU
QUJMRSBgc2VhcmNoX2luZGV4YCAoDQo+IGB3b3JkYCB2YXJjaGFyKDUwKSBOT1QgTlVMTCBERUZB
VUxUICcnLA0KPiBgc2lkYCBpbnQoMTApIHVuc2lnbmVkIE5PVCBOVUxMIERFRkFVTFQgJzAnLA0K
PiBgdHlwZWAgdmFyY2hhcigxNikgREVGQVVMVCBOVUxMLA0KPiBgc2NvcmVgIGZsb2F0IERFRkFV
TFQgTlVMTCwNCj4gVU5JUVVFIEtFWSBgd29yZF9zaWRfdHlwZWAgKGB3b3JkYCxgc2lkYCxgdHlw
ZWApLA0KPiBLRVkgYHNpZF90eXBlYCAoYHNpZGAsYHR5cGVgKSwNCj4gS0VZIGB3b3JkYCAoYHdv
cmRgKQ0KPiApIEVOR0lORT1Jbm5vREIgREVGQVVMVCBDSEFSU0VUPXV0ZjggfA0KPiArLS0tLS0t
LS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLQ0KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KPiAtLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLQ0KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tKw0KPiAxIHJvdyBpbiBzZXQgKDAuMDAgc2VjKQ0KPiANCj4gbXlzcWw+IHNo
b3cgdGFibGUgc3RhdHVzIGxpa2UgInNlYXJjaF9pbmRleCI7DQo+ICstLS0tLS0tLS0tLS0tLSst
LS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLS0tDQo+
IC0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0t
LS0tLS0tKy0tLS0tLS0tDQo+IC0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0t
LS0tLS0tKy0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tDQo+IC0tLS0rLS0tLS0tLS0tLSstLS0t
LS0tLS0tLS0tLS0tKy0tLS0tLS0tLSsNCj4gfCBOYW1lIHwgRW5naW5lIHwgVmVyc2lvbiB8IFJv
d19mb3JtYXQgfCBSb3dzIHwgQXZnX3Jvd19sZW5ndGggfA0KPiBEYXRhX2xlbmd0aCB8IE1heF9k
YXRhX2xlbmd0aCB8IEluZGV4X2xlbmd0aCB8IERhdGFfZnJlZSB8DQo+IEF1dG9faW5jcmVtZW50
IHwgQ3JlYXRlX3RpbWUgfCBVcGRhdGVfdGltZSB8IENoZWNrX3RpbWUgfCBDb2xsYXRpb24gfA0K
PiBDaGVja3N1bSB8IENyZWF0ZV9vcHRpb25zIHwgQ29tbWVudCB8DQo+ICstLS0tLS0tLS0tLS0t
LSstLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLS0t
DQo+IC0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0t
LS0tLS0tLS0tKy0tLS0tLS0tDQo+IC0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0t
LS0tLS0tLS0tKy0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tDQo+IC0tLS0rLS0tLS0tLS0tLSst
LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLSsNCj4gfCBzZWFyY2hfaW5kZXggfCBJbm5vREIgfCAx
MCB8IENvbXBhY3QgfCA2ODkzMjk2IHwgNTggfCA0MDU1MzY3NjggfCAwIHwNCj4gNzI1MTcyMjI0
IHwgMjU1ODUyNTQ0IHwgTlVMTCB8IDIwMTItMDgtMjcgMTQ6NTM6MjAgfCBOVUxMIHwgTlVMTCB8
DQo+IHV0ZjhfZ2VuZXJhbF9jaSB8IE5VTEwgfCB8IHwNCj4gKy0tLS0tLS0tLS0tLS0tKy0tLS0t
LS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0NCj4gLS0t
Ky0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0t
LS0rLS0tLS0tLS0NCj4gLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0t
LS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0NCj4gLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0t
LS0tLS0tLS0rLS0tLS0tLS0tKw0KPiAxIHJvdyBpbiBzZXQgKDAuMDcgc2VjKQ0KPiANCj4gbXlz
cWw+IENSRUFURSBUQUJMRSBgc2VhcmNoX2pvaGFuYCAoIGB3b3JkYCB2YXJjaGFyKDUwKSBOT1Qg
TlVMTA0KPiBERUZBVUxUICcnLCBgY291bnRgIGZsb2F0IERFRkFVTFQgTlVMTCwgUFJJTUFSWSBL
RVkgKGB3b3JkYCkgKQ0KPiBFTkdJTkU9SW5ub0RCIERFRkFVTFQgQ0hBUlNFVD11dGY4IGNvbGxh
dGU9dXRmOF91bmljb2RlX2NpOw0KPiBRdWVyeSBPSywgMCByb3dzIGFmZmVjdGVkICgwLjAwIHNl
YykNCj4gDQo+IG15c3FsPiBpbnNlcnQgaW50byBzZWFyY2hfam9oYW4gc2VsZWN0ICogZnJvbSBz
ZWFyY2hfdG90YWw7DQo+IEVSUk9SIDEwNjIgKDIzMDAwKTogRHVwbGljYXRlIGVudHJ5ICdjxZN1
cicgZm9yIGtleSAnUFJJTUFSWScNCj4gDQo+IA0KPiANCj4gDQo+IC0tDQo+IA0KPiBMaW51eCBC
aWVyIFdhbmRlcnVuZyAyMDEyLCBub3cgYWxzbyBhdmFpbGFibGUgaW4gQmVsZ2l1bSENCj4gQXVn
dXN0LCAxMiB0byAxOSwgRGlrc211aWRlLCBCZWxnaXVtIC0gaHR0cDovL2xidzIwMTIudHV4ZXJh
LmJlDQo=