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

dXRmOCA6IHV0ZjhfZ2VuZXJhbF9jaSAgICAgICAgICAgICAgICBPPW89w5I9w5M9w5Q9w5U9w5Y9
w7I9w7M9w7Q9w7U9w7YgICAgb2UgICAgICBveg0KdXRmOCA6IHV0ZjhfZ2VuZXJhbF9teXNxbDUw
MF9jaSAgICAgICBPPW89w5I9w5M9w5Q9w5U9w5Y9w7I9w7M9w7Q9w7U9w7YgICAgb2UgICAgICBv
eg0KdXRmOCA6IHV0ZjhfZGFuaXNoX2NpICAgICAgICAgICAgICAgICBPPW89wro9w5I9w5M9w5Q9
w5U9w7I9w7M9w7Q9w7UgICAgICBvZT3Fkj3FkyAgb3oNCnV0ZjggOiB1dGY4X3N3ZWRpc2hfY2kg
ICAgICAgICAgICAgICAgTz1vPcK6PcOSPcOTPcOUPcOVPcOyPcOzPcO0PcO1ICAgICAgb2U9xZI9
xZMgIG96DQp1dGY4IDogdXRmOF9lc3Rvbmlhbl9jaSAgICAgICAgICAgICAgIE89bz3Cuj3Dkj3D
kz3DlD3Dsj3Dsz3DtCAgICAgICAgICBvZT3Fkj3FkyAgb3ogICAgICAgw5g9w7gNCnV0ZjggOiB1
dGY4X3VuaWNvZGVfY2kgICAgICAgICAgICAgICAgTz1vPcK6PcOSPcOTPcOUPcOVPcOWPcOyPcOz
PcO0PcO1PcO2ICBvZT3Fkj3FkyAgb3ogICAgICAgw5g9w7gNCnV0ZjggOiB1dGY4X3BvbGlzaF9j
aSAgICAgICAgICAgICAgICAgTz1vPcK6PcOSPcOUPcOVPcOWPcOyPcO0PcO1PcO2ICAgICAgb2U9
xZI9xZMgIG96ICDDkz3DsyAgw5g9w7gNCnV0ZjggOiB1dGY4X3NwYW5pc2hfY2kgICAgICAgICAg
ICAgICAgTz1vPcK6PcOSPcOTPcOUPcOVPcOWPcOyPcOzPcO0PcO1PcO2ICBvZT3Fkj3FkyAgb3og
ICAgICAgw5g9w7gNCnV0ZjggOiB1dGY4X3NwYW5pc2gyX2NpICAgICAgICAgICAgICAgTz1vPcK6
PcOSPcOTPcOUPcOVPcOWPcOyPcOzPcO0PcO1PcO2ICBvZT3Fkj3FkyAgb3ogICAgICAgw5g9w7gN
Cg0KQXMgSSB1bmRlcnN0YW5kIGl0LCB0aGUgb2UgbGlnYXR1cmUgY29sbGF0ZXMgYXMgaXQgaXQg
d2VyZSB0aGUgdHdvIGxldHRlcnMgIm9lIiBmb3IgbW9zdCB1dGY4IGNvbGxhdGlvbnMuICBIb3dl
dmVyIGZvciB1dGY4X2dlbmVyYWwqLCBpdCBjb2xsYXRlcyBhZnRlciBaOg0KDQp1dGY4X2dlbmVy
YWxfY2kgICAgICAgICAgICBYPXggIFk9eT3DnT3DvT3Dvz3FuCAgeXogIFo9ej3FvT3FviAgemgg
IHp6ICDDhj3DpiAgw5A9w7AgIMOYPcO4ICDDnj3DviAgICAgxYE9xYIgIMWSPcWTICDGkiAgx4c9
x4g9x4kNCnV0ZjhfZ2VuZXJhbF9teXNxbDUwMF9jaSAgIFg9eCAgWT15PcOdPcO9PcO/PcW4ICB5
eiAgWj16PcW9PcW+ICB6aCAgenogIMOGPcOmICDDkD3DsCAgw5g9w7ggIMOePcO+ICDDnyAgxYE9
xYIgIMWSPcWTICDGkiAgx4c9x4g9x4kNCg0KSXMgdGhpcyB3aGF0IHlvdSBtZWFuIGJ5ICJiYXJm
cyI/DQoNCj4gLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCj4gRnJvbTogSm9oYW4gRGUgTWVl
cnNtYW4gW21haWx0bzp2ZWdpdmFtcEB0dXhlcmEuYmVdDQo+IFNlbnQ6IFR1ZXNkYXksIEF1Z3Vz
dCAyOCwgMjAxMiAxOjQ5IEFNDQo+IFRvOiBSaWNrIEphbWVzDQo+IENjOiBteXNxbA0KPiBTdWJq
ZWN0OiBSZTogTXlTUUwsIFVURjggYW5kIGNvbGxhdGlvbnMNCj4gDQo+IC0tLS0tIE9yaWdpbmFs
IE1lc3NhZ2UgLS0tLS0NCj4gPiBGcm9tOiAiUmljayBKYW1lcyIgPHJqYW1lc0B5YWhvby1pbmMu
Y29tPg0KPiA+DQo+ID4gVGhlcmUgaXMgYSBzZWN0aW9uIG9uIEdlcm1hbiBTaGFycC1zIGluDQo+
ID4gaHR0cDovL215c3FsLnJqd2ViLm9yZy9kb2MucGhwL2NoYXJjb2xsDQo+ID4gSSBhZ3JlZSB3
aXRoICJkaXJ0eSIuDQo+IA0KPiBZZXMsIHNlZW4gaXQsIGJ1dCB0aGFuayB5b3UuIEknbSBub3Qg
aGF2aW5nIGNoYXJhY3RlciBzZXQgaXNzdWVzLA0KPiBldmVyeXRoaW5nIGlzIG5pY2VseSBVVEY4
LiBJJ20gbWVyZWx5IHJ1bm5pbmcgaW50byB0aGUgc2NoZWnDn2UgYnVnLCBidXQNCj4gd2hpbGUg
dXRmOF91bmljb2RlX2NpIGRvZXMgcHJvcGVybHkgaGFuZGxlIHRoYXQsIGl0IHN0aWwgYmFyZnMg
b24gY8WTcg0KPiAodGhhdCdzIG9lIGluIG9uZSBjaGFyYWN0ZXIpIGFuZCBJJ20gd29uZGVyaW5n
IHdoeS4NCj4gDQo+ID4gQXMgSSB1bmRlcnN0YW5kIGl0LCBhYm91dCA1LjEuMjQsIHRoZXkgc2Fp
ZCAiT29wcywgc2hhcnAtcyBpcw0KPiBjb2xsYXRlZA0KPiA+IHdyb25nLCBsZXQncyBmaXggaXQi
LiAgVGhlIGZpeCBicm9rZSB0aGluZ3MsIGJ1dCB0aGV5IHN0dWNrIGJ5IHRoZQ0KPiA+ICJjb3Jy
ZWN0IiBzb3J0aW5nLiAgRXZlbnR1YWxseSB0aGV5IHNhaWQgIk9oLCBsZXQncyBhZGQgYW5vdGhl
ciwNCj4gPiBjb21wYXRpYmxlLCBjb2xsYXRpb24iLg0KPiA+DQo+ID4gVGhleSB3ZXJlIGNhdWdo
dCBiZXR3ZWVuIGEgcm9jayBhbmQgYSBoYXJkIHBsYWNlLg0KPiANCj4gVGhlIGhhcmQgcGxhY2Ug
YmVpbmcgaGF2aW5nIHRvIGdvICJvb3BzLCBzb3JyeSB3ZSBicm9rZSB0aGluZ3MsIHdlDQo+IHJl
dmVydGVkIHRoZSBjaGFuZ2UgYW5kIHdpbGwgaW50cm9kdWNlIGEgbmV3IGRlZmF1bHQgY29sbGF0
aW9uIGluIHRoZQ0KPiBuZXh0IHZlcnNpb24iPyBZZXMsIHBvb3Igc29mdHdhcmUgdmVuZG9ycywg
d2h5IGRvIHBlb3BsZSBhbHdheXMgZXhwZWN0DQo+IHRoZW0gdG8gYWRtaXQgdGhleSBtYWRlIGEg
bWlzdGFrZSBpbiBqdWRnZW1lbnQuDQo+IA0KPiBBbmQsIG9mIGNvdXJzZSwgImFsdGVyIHRhYmxl
IGZvbyBjb2xsYXRlIHV0ZjhfZ2VuZXJhbF9teXNxbDUwMF9jaSINCj4gZG9lc24ndCBkbyB3aGF0
IHlvdSBob3BlLCBlaXRoZXIuIEl0IGNoYW5nZXMgdGhlIHRhYmxlJ3MgZGVmYXVsdA0KPiBjb2xs
YXRpb24gbmljZWx5LCBhbmQgdGhlbiBleHBsaWNpdGx5IGFkZHMgdGhlICpvbGQqIGNvbGxhdGlv
biB0byBhbGwNCj4gdGhlIHJvd3MgeW91IHdlcmUgaG9waW5nIHRvIGhhdmUgZml4ZWQuDQo+IA0K
PiBHdWVzcyBJJ2xsIGJlIGZpeGluZyBpdCBtYW51YWxseSAod2VsbCwgc2VkIGlzIG15IGZyaWVu
ZCkgaW4gYQ0KPiBteXNxbGR1bXAgYmVmb3JlIHN5bmNpbmcgdXAgdGhlIHNlY29uZCBub2RlIGFm
dGVyIGl0J3MgYmVlbiB1cGdyYWRlZC4NCj4gDQo+IC0tDQo+IExpbnV4IEJpZXIgV2FuZGVydW5n
IDIwMTIsIG5vdyBhbHNvIGF2YWlsYWJsZSBpbiBCZWxnaXVtIQ0KPiBBdWd1c3QsIDEyIHRvIDE5
LCBEaWtzbXVpZGUsIEJlbGdpdW0gLSBodHRwOi8vbGJ3MjAxMi50dXhlcmEuYmUNCg==