X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 71297D1C9BA for ; Mon, 23 Feb 2004 08:44:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 01659-09 for ; Mon, 23 Feb 2004 04:44:24 -0400 (AST) Received: from mail.hyd.idv.tw (unknown [210.243.190.201]) by svr1.postgresql.org (Postfix) with ESMTP id AAB79D1C969 for ; Mon, 23 Feb 2004 04:44:20 -0400 (AST) Received: from thlgist2 (thlgist2.thl.ncku.edu.tw [140.116.217.162]) by mail.hyd.idv.tw (Postfix) with SMTP id AB0D5DC85 for ; Mon, 23 Feb 2004 03:47:31 -0500 (EST) Message-ID: <000801c3f9e9$3ec993c0$a2d9748c@thlgist2> From: "john" To: Subject: unicode(utf-8) problem ! Date: Mon, 23 Feb 2004 16:44:26 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C3FA2C.4C404010" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200402/395 X-Sequence-Number: 17085 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C3FA2C.4C404010 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: quoted-printable the chinese utf-8 code haves 3 bytes When I use the query command Like " select * from phpbb_users where user= name=3D'e??e?3' " the Result is Too Much Records! :-( user_id=3D9522, username=3D e??e2? user_id=3D8261, username=3D e??e?=A1K user_id=3D6364, username=3D e??e?=A2X user_id=3D6141, username=3D e??e?2 user_id=3D5490, username=3D e??e?1 user_id=3D4694, username=3D e??e ? user_id=3D2618, username=3D e??e?? user_id=3D1979, username=3D e??e?3 ------=_NextPart_000_0005_01C3FA2C.4C404010 Content-Type: text/html; charset="big5" Content-Transfer-Encoding: quoted-printable
the chinese utf-8 code haves  3 bytes
 
When I use the query command Like   "&nb= sp;=20 select * from phpbb_users where=20 username=3D'阿至' "
 
the Result is Too Much Records! :-(

user_id=3D9522, username=3D=20 阿貝
user_id=3D8261, username=3D &= eacute;˜¿è¶=A1K
user_id=3D6364, username=3D=20 阿è=A2X
user_id=3D6141, username=3D &ea= cute;˜¿è²
user_id=3D5490, username=3D=20 阿苹
user_id=3D4694, username=3D = 阿蠻
user_id=3D2618, username=3D= =20 阿虎
user_id=3D1979, username=3D = 阿至
 
------=_NextPart_000_0005_01C3FA2C.4C404010--