From: john <john@hyd.idv.tw>
To: pgsql-sql@postgresql.org
Subject: unicode(utf-8) problem !
Date: Mon, 23 Feb 2004 16:44:26 +0800
Message-ID: <000801c3f9e9$3ec993c0$a2d9748c@thlgist2> (raw)
the chinese utf-8 code haves 3 bytes
When I use the query command Like " select * from phpbb_users where username='e??e?3' "
the Result is Too Much Records! :-(
user_id=9522, username= e??e2?
user_id=8261, username= e??e?¡K
user_id=6364, username= e??e?¢X
user_id=6141, username= e??e?2
user_id=5490, username= e??e?1
user_id=4694, username= e??e ?
user_id=2618, username= e??e??
user_id=1979, username= e??e?3
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: john@hyd.idv.tw
Subject: Re: unicode(utf-8) problem !
In-Reply-To: <000801c3f9e9$3ec993c0$a2d9748c@thlgist2>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox