X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DE6CD565D9 for ; Fri, 11 Mar 2005 07:14:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17838-07 for ; Fri, 11 Mar 2005 07:14:28 +0000 (GMT) Received: from sranda.klamovka.kosire.czf (unknown [82.113.63.66]) by svr1.postgresql.org (Postfix) with ESMTP id C0660565F7 for ; Fri, 11 Mar 2005 07:14:26 +0000 (GMT) Received: (qmail 1313 invoked from network); 11 Mar 2005 08:14:26 +0100 Received: from startnet.klamovka.kosire.czf (HELO ?192.168.11.101?) (10.15.6.17) by smtp.klamovka.kosire.czf with AES256-SHA encrypted SMTP; 11 Mar 2005 08:14:26 +0100 Message-ID: <42314551.4010909@startnet.cz> Date: Fri, 11 Mar 2005 08:14:25 +0100 From: =?UTF-8?B?TWlyb3NsYXYgxaB1bGM=?= Organization: StartNet s.r.o. User-Agent: Mozilla Thunderbird 1.0 (X11/20041208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: star star Cc: pgsql-admin@postgresql.org Subject: Re: Unicode! References: <20050311012012.61766.qmail@web53706.mail.yahoo.com> In-Reply-To: <20050311012012.61766.qmail@web53706.mail.yahoo.com> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/mixed; boundary="------------010503030302020808070903" X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/172 X-Sequence-Number: 16670 This is a multi-part message in MIME format. --------------010503030302020808070903 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit First, I would try to set encoding (charset) for the insert.htm page to UTF-8. That might help. If not, let us know. Miroslav Šulc star star wrote: > I use PostgreSQL 8! > > I have 2 file: > insert.htm > > > Untitled Document > > > >
> > >
> > > postgre_insert.jsp > <%@ page contentType="text/html; charset=utf-8" import="java.sql.*" > errorPage="" %> > <% > String username=request.getParameter("username"); > String str="insert into user_table values('"+username+"','try')"; > Class.forName("org.postgresql.Driver"); > String url = "jdbc:postgresql://localhost:5432/try"; > Connection conn = DriverManager.getConnection(url, "postgres", "pass"); > PreparedStatement s = conn.prepareStatement(str); > s.executeUpdate(); > out.println("OK"); > %> > I input "Tiếng Việt" on textfield and click Submit button. Insertion > is successed. > But, when i view data in pgAdmin III(version 1.2.0), data is " Tiếng > Việt ". > Can you help me!? > > ------------------------------------------------------------------------ > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site! > --------------010503030302020808070903 Content-Type: text/x-vcard; charset=utf-8; name="miroslav.sulc.vcf" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="miroslav.sulc.vcf" YmVnaW46dmNhcmQNCmZuO3F1b3RlZC1wcmludGFibGU6TWlyb3NsYXYgPUM1PUEwdWxjDQpu O3F1b3RlZC1wcmludGFibGU6PUM1PUEwdWxjO01pcm9zbGF2DQpvcmc6U3RhcnROZXQgcy5y Lm8uDQphZHI7cXVvdGVkLXByaW50YWJsZTtxdW90ZWQtcHJpbnRhYmxlOjs7VnJjaGxpY2s9 QzM9QTlobyAxNjEvNTtQcmFoYSA1OzsxNTAgMDA7PUM0PThDZXNrPUMzPUExIHJlcHVibGlr YQ0KZW1haWw7aW50ZXJuZXQ6bWlyb3NsYXYuc3VsY0BzdGFydG5ldC5jeg0KdGl0bGU6Q0VP DQp0ZWw7d29yazorNDIwIDI1NyAyMjUgNjAyDQp0ZWw7Y2VsbDorNDIwIDYwMyA3MTEgNDEz DQp4LW1vemlsbGEtaHRtbDpUUlVFDQp1cmw6aHR0cDovL3d3dy5zdGFydG5ldC5jeg0KdmVy c2lvbjoyLjENCmVuZDp2Y2FyZA0KDQo= --------------010503030302020808070903--