From: Date: April 13 2005 3:59am Subject: Re: utf8 questions? List-Archive: http://lists.mysql.com/mysql/182523 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: base64 SSBkb24ndCBrbm93IGlmIHRoaXMgaXMgdGhlIHJpZ2h0IHdheSB0byBnZXQgYmFjayB0byB0aGUg dGhyZWFkLApob3BlZnVsbHkgdGhpcyB3aWxsIGJlIHBsYWNlZCB1bmRlciB0aGUgc2FtZSB0aHJl YWQuIDopCgpUaGFuayB5b3UgZm9yIHlvdXIgaW5wdXQsIExpZ2F5YS4KYWhoaC4uLm1ic3RyaW5n LCBJIHRpcmVkIHRoYXQgYWZ0ZXIgaSBnb3QgeW91ciByZXBseSwgYnV0IGl0IGRpZG4ndApoZWxw IHRvIHNvbHZlIHRoZSBwdXp6bGUsCgpJIGRpZCBtYW5hZ2UgdG8gZmluZCBteXNlbGYgYSBzb2x1 dGlvbiBsYXN0IG5pZ2h0IHRob3VnaCwgCgppdCB0dXJucyBvdXQgdGhhdCBldmVuIGlmIEkgc2V0 IC0tZGVmYXVsdC1jaGFyYWN0ZXItc2V0ID0gdXRmLTggaW4gdGhlCm9wdGlvbiBmaWxlLAp0aGUg Y2hhcmFjdGVyX3NldF9jbGllbnQsIGNoYXJhY3Rlcl9zZXRfcmVzdWx0cywKY2hhcmFjdGVyX3Nl dF9jb25uZWN0aW9uIHNvbWVob3cgYXJlIHN0aWxsIGxhdGluMS4KCkkgZG9uJ3Qga25vdyBpZiB0 aGlzIGlzIHNvbWUgYnVnIGluIG15c3FsICgtLWRlZmF1bHQtY2hhcmFjdGVyLXNldCBpbgpvcHRp b24gZmlsZSBoYXMgbGl0dGxlIG9yIG5vIGVmZmVjdHM/PyksIG9yIGl0IGhhcyB0byBkbyB3aXRo IHBocAppbnRlcm5hbCBlbmNvZGluZyhwaHAgaXNzdWVzIGEgbGF0aW4xIGNoYXJzZXQgdXBvbiBl dmVyeSBteXNxbApjb25uZWN0aW9uIGJ5IGRlZmF1bHQ/PyBpcyB0aGF0IHBvc3NpYmxlPyBJIGFt IHN0aWxsIHdvbmRlcmluZy4uLi4pCmFueXdheSwgaSBtYW5hZ2UgdG8gaXNzdWUgYSBTRVQgTkFN RVMgICd1dGY4JzsgcXVlcnkgYWZ0ZXIgZXZlcnkKY29ubmVjdGlvbiwgYW5kIGV2ZXJ5dGhpbmcg d29ya3Mgd2VsbC4KCkknbSBwcmV0dHkgc2F0aXNmaWVkIHdpdGggdGhpcyByZXN1bHQgYXQgdGhl IG1vbWVudCwgbm93IGkgY2FuIGNhdGNoCnNvbWUgc2xlZXBzIGhhcHBpbHkuCgp0aGFuayB5b3Ug YWdhaW4sCgpkZS16aGFvIGNhaQoKT24gNC8xMy8wNSwgTGlnYXlhIFR1cm1lbGxlIDxsaWdAbWdw dC5jb20+IHdyb3RlOgo+IGhhdmUgeW91IGFsdGVyZWQgeW91ciBwaHAuaW5pIGZpbGUgaW4gdGhl IG1ic3RyaW5nIHNlY3Rpb24/ICBJIGRvbid0Cj4ga25vdyBpZiBpdCBtYWtlcyBhIGRpZmZlcmVu Y2UgYnV0IEkgaGF2ZSBhbHdheXMgY2hhbmdlZCBteSB0bzoKPiAKPiA7IGxhbmd1YWdlIGZvciBp bnRlcm5hbCBjaGFyYWN0ZXIgcmVwcmVzZW50YXRpb24uCj4gbWJzdHJpbmcubGFuZ3VhZ2UgPSB1 dGY4Cj4gOyBpbnRlcm5hbC9zY3JpcHQgZW5jb2RpbmcuCj4gbWJzdHJpbmcuaW50ZXJuYWxfZW5j b2RpbmcgPSB1dGY4Cj4gCj4gYW5kIGhhdmUgbmV2ZXIgaGFkIGEgcHJvYmxlbS4KPiAKPiBELiB3 cm90ZToKPiAKPiA+IEhpLCB0aGlzIG1pZ2h0IG5vdCBiZSBhIG15c3FsIHByb2JsZW0sIGJ1dCBo b3BlZnVsbHkgc29tZW9uZSB3aWxsIGJlCj4gPiBhYmxlIHRvIGFuc3dlciwgdGhhbmtzIGluIGFk dmFuY2UuCj4gPgo+ID4gSSBub3RpY2UgYSBsb3Qgb2YgcGVvcGxlIGhhZCBhc2tlZCB0aGUgc2Ft ZSBxdWVzdGlvbiBhbmQgdGhlIHR5cGljYWwKPiA+IHJlc3BvbnNlIGluIHRoZSBtYWlsaW5nIGxp c3Qgc2VlbWVkIHRvIGJlLCAibWFrZSBzdXJlIHlvdSBlbmNvZGUgdGhlCj4gPiBkYXRhIHRvIHV0 Zi04IGJlZm9yZSBpbnNlcnQgaW50byBteXNxbC4uLiIsIG9yIHNvbWV0aGluZyBzaW1pbGlhci4K PiA+Cj4gPiBJIGhhdmUgdHJpZWQgdGhhdCB0b28sIGJ1dCBzb21laG93IGl0IGRpZG4ndCB3b3Jr IG91dC4uCj4gPgo+ID4gd2hhdCBpJ20gdHJ5aW5nIHRvIGRvIGlzLCB0byBtYWtlIGV2ZXJ5dGhp bmcgdXRmLTgsIHNvIHRoYXQgdGhlcmUgaXMKPiA+IG5vIGNvbnZlcnNpb24gYmV0d2VlbiBkYXRh YmFzZSA8LT4gY29ubmVjdGlvbiA8LT4gcGhwIDwtPiBvdXRwdXQgKGF0Cj4gPiBsZWFzdCBvbiB0 aGUgc2VydmVyIGxldmVsKQo+ID4KPiA+IHRoZSBmaXJzdCB0aGluZyBpIGRpZCB3YXMgdG8gc2V0 IG15c3FsIGNoYXJzZXQgdmFyaWFibGVzOgo+ID4gY2hhcmFjdGVyIHNldCBjbGllbnQgIHV0ZjgK PiA+IGNoYXJhY3RlciBzZXQgY29ubmVjdGlvbiAgdXRmOAo+ID4gY2hhcmFjdGVyIHNldCBkYXRh YmFzZSAgdXRmOAo+ID4gY2hhcmFjdGVyIHNldCByZXN1bHRzICB1dGY4Cj4gPiBjaGFyYWN0ZXIg c2V0IHNlcnZlciAgdXRmOAo+ID4gY2hhcmFjdGVyIHNldCBzeXN0ZW0gIHV0ZjgKPiA+Cj4gPiBh bGwgZGF0YWJhc2UsIHRhYmxlcyBhcmUgY3JlYXRlZCBpbiB1dGY4Cj4gPgo+ID4gb3V0cHV0IEhU TUwgY2hhcnNldDogdXRmLTgKPiA+IChJIGV2ZW4gc2V0IHRoZSBwaHAgY29kZSB0byB1dGYtOC4u LmRvbnQga25vdyBpZiB0aGF0J3MgdXNlZnVsLi4uKQo+ID4KPiA+IGNhc2UgMToKPiA+IHdoZW4g aSBpbnB1dCB0cmFkaXRpb25hbCBjaGluZXNlIGNoYXJhY3RlcnMgb24gaW50ZXJuZXQgZXhwbG9y ZXIKPiA+IChjaGFyc2V0IHV0Zi04KSBhbmQgc3RvcmUgdGhlbSBpbnRvIGRhdGFiYXNlLCBzdXBw b3NpbmdseSB0aGVyZSdzIG5vCj4gPiBuZWVkIHRvIGdvIHRocm91Z2ggYW55IGVuY29kaW5nIGNv bnZlcnNpb24/ICh0aGUgYnJvd3NlciB3aWxsIHNlbmQgdGhlCj4gPiBkYXRhIGluIHV0Zi04PyBp IGRpZCBhIHV0Zi04IHZhbGlkYXRpb24sIGp1c3QgdG8gbWFrZSBzdXJlIGFsbCB0aGUKPiA+IGRh dGEgYXJlIHV0Zi04IGJlZm9yZSBpIGluc2VydCwgYW5kIHRoZSBkYXRhIHdhcyB1dGYtOCB2YWxp ZGF0ZWQuKQo+ID4KPiA+IHdoZW4gSSBleHRyYWN0IHRoZSBkYXRhIGZyb20gbXlzcWw6Cj4gPiAx LiBpdCB3b3JrcyBmaW5lLCBhbG1vc3QgYWxsIGNoYXJhY3RlcnMgY2FuIGRpc3BsYXkgcHJvcGVy bHksIGV4Y2VwdAo+ID4gZm9yIHNvbWUgY2hhcmFjdGVycy4gKGV4YW1wbGU6IL1ZINhTLCB3aWxs IHNob3cgdXAgYXMgvYcg2HgpCj4gPiAyLiBOT05FIG9mIHRoZSBkYXRhIHNob3dlZCB1cCBjb3Jy ZWN0bHkgaW4gbXlzcWwgcXVlcnkgYnJvd3Nlcgo+ID4KPiA+IGNhc2UgMjoKPiA+IGkgaW5wdXRl ZCBpbiBhIHNldCBvZiB0ZXN0IGRhdGEgaW4gbXlzcWwgcXVlcnkgYnJvd3NlciwgYW5kIGl0IHNo b3dzCj4gPiB1cCBwcm9wZXJseSBpbiBteXNxbCBxdWVyeSBicm93c2VyLCBidXQgd2hlbiBpIHRy eSB0byBmZXRjaCB0aGUgZGF0YQo+ID4gZnJvbSBteSBwaHAsIGFuZCByZW5kZXIgaXQgdG8gYnJv d3NlciggIGNoYXJzZXQgdXRmLTgpLCBpdCBzaG93cyB1cAo+ID4gPz8/Pz8gKHRoYXQncyB0aGUg cHJvYmxlbSBvdGhlciBwcGwgYXJlIGhhdmluZyBpIGd1ZXNzLCBidXQgaSBoYXZlCj4gPiBkb25l IGFsbCB0aG9zZSBlbmNvZGluZyBzdGVwcywgZGlkIEk/KQo+ID4KPiA+IHBocE15QWRtaW4gKG15 IHZlcnNpb24gMi42LjFiZXRhLCBhbmQgMi42LjEpIGJlaGF2ZXMgdGhlIHNhbWUgd2F5Cj4gPiBt eXNxbCBxdWVyeSBicm93c2VyIGRvZXMuCj4gPgo+ID4ganVzdCB0byBtYWtlIHRoaW5ncyBsZXNz IGNvbXBsaWNhdGVkLCBpbnN0ZWFkIG9mIGdldHRpbmcgZGF0YSBmcm9tIGJyb3dzZXIsCj4gPiBp IHRyaWVkIHRvIGdldCBmcm9tIHVmdC04IGVuY29kZWQgZmlsZXMgKHNhbWUgYmFkIHJlc3VsdCks Cj4gPiBhbmQgaSB0aXJlZCB0byBtYWtlIHRoZSBkYXRhIGNvbnRhaW5lZCBpbiBhIHZhcmlhYmxl IGluc2lkZSB0aGUgcGhwCj4gPiBjb2RlIHBhZ2UodXRmLTggZW5jb2RlZCksIHNhbWUgcHJvYmxl bSBvY2N1cmVkLgo+ID4gYW5kIGxhc3RseSwgaSB0cmllZCB0byBvdXRwdXQgdGhlIHBvc3RlZCBk YXRhIGJhY2sgdG8gYnJvd3Nlcih3aXRob3V0Cj4gPiBnb2luZyB0aHJvdWdoIGRhdGFiYXNlKSwg aW50ZXJuZXQgZXhwbG9yZXIgcmVuZGVycyBhbGwgY2hhcmFjdGVycwo+ID4gcHJvcGVybHkuCj4g Pgo+ID4gc28gaXQgc2VlbXMgdG8gbWUgdGhhdCBpJ20gbWlzc2luZyBzb21ldGhpbmcgb24gdGhl IHBocCAmIG15c3FsCj4gPiBjb21tdW5pY2F0aW9uIGxldmVsLiBpcyB0aGF0IHNvPwo+ID4KPiA+ IG90aGVyIGluZm9ybWF0aW9uOgo+ID4gcGhwIDUuMC4zCj4gPiBhcGFjaGUgMi4wLjUzCj4gPiB3 aW5kb3dzIHhwIHNwMgo+ID4gbXlzcWwgNC4xLjEwYSB3aXRoIGlubm9EQi91dGY4IGRlZmF1bHQK PiA+IG15c3FsIHF1ZXJ5IGJyb3dzZXIgMS4xLjYKPiA+IHBocE15QWRtaW4gMi42LjEKPiA+IG15 c3FsICYgbXlzcWxpCj4gPgo+ID4gSSBub3RpY2UgdGhhdCBwaHBNeUFkbWluIGRvZXNuJ3QgaGF2 ZSB0aGlzIHByb2JsZW0gd2hlbiBpdCBkaXNwbGF5cwo+ID4gdGhlIGRhdGEgaXQgc3RvcmVzLCBw cm9iYWJseSB0aGlzIGlzIG5vdCBhIG15c3FsIGlzc3VlLCAocGhwTXlBbWluCj4gPiB3b3JrcyB3 ZWxsIHdpdGggTXlTcWwgUXVlcnkgQnJvd3NlciB0b28sIGkgbXVzdCBoYXZlIG1pc3NlZCBzb21l dGhpbmcKPiA+IGluIHBocCBpIGd1ZXNzKSwgaG9wZWZ1bGx5IHNvbWVvbmUgd2lsbCBiZSBhYmxl IHRvIHRlbGwgbWUsIHNvIG15Cj4gPiBxdWVzdGlvbnMgYXJlOgo+ID4KPiA+IGFmdGVyIHNldHRp bmcgbXlzcWwgY2hhcnNldCB0byB1dGYtOCwgYW5kIGJlc2lkZSBtYWtpbmcgc3VyZSB0aGUgZGF0 YQo+ID4gaXMgZW5jb2RlZCBpbiB1dGYtOCBwcm9wZXJseSAod2hpY2ggaSB0aGluayBpIGRpZCks IHdoYXQgZWxzZSBkbyBpCj4gPiBuZWVkIHRvIGRvIG9uIHRoZSBwcm9ncmFtbWluZyBsZXZlbD8K PiA+IG9yIGNvdWxkIGkgaGF2ZSBkb25lIHdyb25nIGluIHNvbWUgb2YgdGhlIHN0ZXBzPwo+ID4g b3IgY291bGQgaSBoYXZlIG5vdCBkb25lIHNvbWUgbmVjZXNzYXJ5IHN0ZXBzIHRvIHdvcmsgd2l0 aCBteXNxbAo+ID4gY2hhcnNldCBmZWF0dXJlcz8KPiA+Cj4gPiBhbmQgbGFzdGx5LAo+ID4gaXMg aXQgcG9zc2libGUgdG8gZGV2ZWxvcGUgYW4gZW5jb2RpbmcgY29udmVyc2lvbiBmcmVlIHByb2dy YW0oYXQKPiA+IGxlYXN0IG9uIHRoZSBzZXJ2ZXIocykgbGV2ZWwpPwo+ID4KPiA+IGFueSBpbnB1 dHMgd2lsbCBiZSBhcHByZWNpYXRlZC4gSSB0aGFuayBldmVyeW9uZSBpbiBhZHZhbmNlLgo+ID4K PiA+IGRlLXpoYW8KPiA+Cj4gCj4gLS0KPiBSZXNwZWN0ZnVsbHksCj4gTGlnYXlhIFR1cm1lbGxl Cj4gCj4gIkxpZmUgaXMgYSBnYW1lLi4uLiBzbyBoYXZlIGZ1biIKPiAKPiAKPgo=