X-Original-To: pgsql-jdbc-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9DB3AD1C910; Wed, 6 Aug 2003 01:13:11 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 58618-07; Tue, 5 Aug 2003 22:11:55 -0300 (ADT) Received: from mail.accunettech.com (unknown [210.21.18.70]) by svr1.postgresql.org (Postfix) with ESMTP id E83F1D1C95B; Tue, 5 Aug 2003 22:12:58 -0300 (ADT) Received: from leon ([192.168.0.31]) (authenticated) by mail.accunettech.com (8.11.6/8.11.6) with ESMTP id h761AmB21752; Wed, 6 Aug 2003 09:10:48 +0800 Message-ID: <001201c35bb7$8c945520$1f00a8c0@leon> From: "LEON" To: "Kurt Overberg" , , References: <20030726193947.B1636@natasha.ward.six> <3F2FE52E.9000207@hotdogrecords.com> Subject: Re: [SQL] JDBC encoding problem Date: Wed, 6 Aug 2003 09:10:38 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/64 X-Sequence-Number: 7903 SSBoYXZlIG1ldCB0aGUgc2FtZSBwcm9ibGVtIHdoZW4gIEkgZGVhbCB3aXRo IGNoaW5lc2UuDQpJIGd1ZXNzIHRvbWNhdCBhbmQgamRiYyBwcm9kdWNlZCB0 aGlzIGJ1Zy4NCkJ1dCB5b3UgbWF5IHNvbHV0ZSB0aGUgY2hhcnNldCBkaXNw bGF5IHByb2JsZW0uDQpZb3UgY2hhbmdlIHRoZSBkYXRhYmFzZSdzIGNoYXJz ZXQgaXMgdXNlbGVzcyB3aGVuIHlvdSBjb25uZWN0ZWQgREIgd2l0aCBKREJD LiBZb3Ugc2hvdWxkIGNvbnZlcnQgSW5wdXQgVGV4dCB3aXRoIFVURi04IGJl Zm9yZSBzYXZlZCBpbiBkYXRhYmFzZS4gV2hlbiB5b3UgZmV0Y2ggZGF0YSBm cm9tIERBVEFCQVNFICx5b3Ugc2hvdWxkIGNvbnZlcnQgb3V0cHV0IGRhdGEg d2l0aCBzb21lIGNoYXJzZXQgKEYuRTpHQkspIGJlZm9yZSB5b3UgZGlzcGxh eSB0aGUgZGF0YSBpbiBwYWdlLg0KDQoNClRoZXJlIGlzIHNvbWUgamF2YSBj b2RlIEkgdXNlZC5Ib3BlIHRoZXkgd2lsbCBoZWxwIHlvdS4NCi8vT3V0cHV0 Og0KT3V0cHV0U3RyZWFtIGZpbGVPdXQgPSBuZXcgRmlsZU91dHB1dFN0cmVh bShvdXRwdXRGaWxlTmFtZSk7DQoNCmZpbGVPdXQud3JpdGUoZGF0YS5nZXRC eXRlcygiR0JLIikpOyAgLy9HQkvjgIFHQjIzMTLjgIFCSUc144CBVVRGOA0K DQovL0lucHV0Og0KSW5wdXRTdHJlYW0gZmlsZUluID0gbmV3IEZpbGVJbnB1 dFN0cmVhbShpbnB1dEZpbGVOYW1lKTsNCg0KaW50IGkgPSBmaWxlSW4ucmVh ZChidWZmKTsNCg0KU3RyaW5nIGRhdGEgPSBuZXcgU3RyaW5nKGJ1ZmYsIlVU RjgiKTsNCg0KDQpCZXN0IHJlZ2FyZHMuDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGxlb24NCg0KLS0tLS0g T3JpZ2luYWwgTWVzc2FnZSAtLS0tLSANCkZyb206ICJLdXJ0IE92ZXJiZXJn IiA8a3VydEBob3Rkb2dyZWNvcmRzLmNvbT4NClRvOiA8cGdzcWwtc3FsQHBv c3RncmVzcWwub3JnPjsgPHBnc3FsLWpkYmNAcG9zdGdyZXNxbC5vcmc+DQpT ZW50OiBXZWRuZXNkYXksIEF1Z3VzdCAwNiwgMjAwMyAxOjExIEFNDQpTdWJq ZWN0OiBbU1FMXSBKREJDIGVuY29kaW5nIHByb2JsZW0NCg0KDQo+IA0KPiBJ J20gaGF2aW5nIGEgcmF0aGVyIHN0cmFuZ2UgcHJvYmxlbSB0aGF0IEknbSBo b3Bpbmcgc29tZW9uZSBjYW4gaGVscCBtZSANCj4gd2l0aC4gIEknbSB1c2lu ZyBTdHJ1dHMgMS4wL2pzcCBvbiBEZWJpYW4gbGludXggdW5kZXIgVG9tY2F0 IDQuMS54IGFuZCANCj4gdGhlIGJsYWNrZG93biBKVk0gIC4gIEknbSBhdHRl bXB0aW5nIHRvIGNvbnZlcnQgbXkgY3VycmVudCBTUUxfQVNDSUkgDQo+IGRh dGFiYXNlIHRvIFVOSUNPREUuICBJJ20gbmV3IHRvIHRoaXMsIHNvIGFtIG1v c3QgbGlrZWx5IG1ha2luZyBhIGZldyANCj4gbWlzdGFrZXMuICBIZXJlJ3Mg d2hhdCBJJ3ZlIGRvbmUgc28gZmFyOg0KPiANCj4gbyAgQ29udmVydGVkIGRh dGFiYXNlIGVuY29kaW5nIHRvIGJlIFVOSUNPREUuICBJJ20gcHJldHR5IHN1 cmUgdGhpcyBwYXJ0IA0KPiB3b3JrZWQgb2theS4gIChkaWQgYSBwZ19kdW1w LCB0aGVuIGljb252IC1mIDg4NTlfMSAtdCBVVEYtOCwgdGhlbiANCj4gY3Jl YXRlZCBuZXcgZGIgd2l0aCBlbmNvZGluZyBVTklDT0RFIGFuZCByZWxvYWRl ZC0gbm8gZXJyb3JzIHVwb24gcmVsb2FkKQ0KPiANCj4gc3Bhcmt5On4kIHBz cWwgLWwNCj4gICAgICAgICAgTGlzdCBvZiBkYXRhYmFzZXMNCj4gICAgIE5h bWUgICAgfCAgT3duZXIgICB8IEVuY29kaW5nDQo+IC0tLS0tLS0tLS0tKy0t LS0tLS0tLS0rLS0tLS0tLS0tLS0NCj4gICB1bml0ZXN0ICAgfCBrdXJ0ICAg ICB8IFVOSUNPREUNCj4gICB0ZW1wbGF0ZTEgfCBwb3N0Z3JlcyB8IFNRTF9B U0NJSQ0KPiAoMiByb3dzKQ0KPiANCj4gDQo+IG8gIHNldCBjbGllbnRfZW5j b2RpbmcgdG8gJ1VURjgnOw0KPiANCj4gbyAgSW4gbXkgSlNQIGZpbGVzLCBJ IHNldCB0aGUgZm9sbG93aW5nIGF0IHRoZSB0b3Agb2YgZWFjaDoNCj4gDQo+ IDwlQCBwYWdlIGxhbnVhZ2U9ImphdmEiIHBhZ2VFbmNvZGluZz0iVVRGLTgi ICU+DQo+IA0KPiANCj4gTm93LCB0byB0ZXN0IHRoaXMsIEkgZ28gdG8gYSBq YXBhbmVzZSBwYWdlLCBjb3B5IHNvbWUgdGV4dCwgdGhlbiBwYXN0ZSANCj4g aXQgaW50byBhIGZvcm0sIHRoYXQgZ2V0cyBzdWJtaXR0ZWQgdG8gdGhlIHNl cnZlciBhbmQgc2F2ZWQgaW50byB0aGUgREIuIA0KPiBUaGVuIEkgdHJ5IHRv IGRpc3BsYXkgd2hhdCBJIGdvdCBiYWNrIGZyb20gdGhlIGRhdGFiYXNlLiAg SXQgY29tZXMgb3V0IA0KPiBnYXJibGVkLiAgSE9XRVZFUi0gaWYgSSBsZWF2 ZSB0aGUgJ3BhZ2VFbmNvZGluZycgb3V0IG9mIG15IGRpc3BsYXkgLmpzcCAN Cj4gZmlsZSBpdCBzdGlsbCBjb21lcyBvdXQgZ2FyYmxlZCwgVU5USUwgSSBz ZXQgVVRGLTggbWFudWFsbHkgaW4gbXkgDQo+IGJyb3dzZXJzIENoYXJhY3Rl ciBFbmNvZGluZyBzZXR0aW5ncyAoYm90aCBtb3ppbGxhIGFuZCBJRSkuICBU aGVuIHRoZSANCj4gamFwYW5lc2UgY2hhcmFjdGVycyByZW5kZXIgZmluZSAo anVzdCBsaWtlIEkgZW50ZXJlZCB0aGVtKS4NCj4gDQo+IFZlcnkgc3RyYW5n ZS4gIFdoYXQncyBjb25mdXNpbmcgaXMgdGhhdCB3aGVuIEkgc2V0IHRoZSBw YWdlRW5jb2RpbmcgdG8gDQo+ICdVVEYtOCcsIHRoZSBjaGFyYWN0ZXJzIGRv bid0IHJlbmRlciBwcm9wZXJseSwgYW5kIGFzIGZhciBhcyBJIGNhbiB0ZWxs LCANCj4gdGhhdHMgdGhlIHNhbWUgYXMgbWFudWFsbHkgc2V0dGluZyB0aGUg YnJvd3NlciBtYW51YWxseS4gIEkgbXVzdCBiZSANCj4gZG9pbmcgc29tZXRo aW5nIHdyb25nIGJlY2F1c2UgSSBnZXQgdGhlIHNhbWUgcmVzdWx0cyBpbiBJ RSBhbmQgbW96aWxsYSANCj4gKHJlY2VudCBidWlsZCkuDQo+IA0KPiBXaGF0 IG1heSBiZSB0aGUgcHJvYmxlbS0gSSBkb24ndCBkbyBhbnl0aGluZyBkaWZm ZXJlbnRseSB3aGVuIGdldHRpbmcgDQo+IHRoZSBkYXRhIG91dCBvZiB0aGUg ZGF0YWJhc2UsIGp1c3Qgc3RhbmRhcmQgDQo+IHJlc3VsdHNldC5nZXRTdHJp bmcoImNvbHVtbiIpOyAgRG8gSSBuZWVkIHRvIGNoYW5nZSB0aGF0IGNhbGws IHRvIGhhbmRsZSANCj4gdGhlIHBvdGVudGlhbGx5IFVURi04IGVuY29kZWQg c3RyaW5ncz8gIEkgY2FuJ3QgZmluZCBhbnl0aGluZyBvbiB0aGF0IGF0IA0K PiBhbGwgd2l0aCBnb29nbGUvdXNlbmV0Lg0KPiANCj4gQW55IGFuZCBhbGwg aGVscCwgc3VnZ2VzdGlvbnMgb3IgcG9pbnRlcnMgd291bGQgYmUgZ3JlYXRs eSBhcHByZWNpYXRlZC4NCj4gDQo+IFRoYW5rcyENCj4gDQo+IC9rdXJ0DQo+ IA0KPiANCj4gDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLShlbmQg b2YgYnJvYWRjYXN0KS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KPiBU SVAgNDogRG9uJ3QgJ2tpbGwgLTknIHRoZSBwb3N0bWFzdGVyDQo+IA0K