unicode(utf-8) problem !

From: "john" <john(at)hyd(dot)idv(dot)tw>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: unicode(utf-8) problem !
Date: 2004-02-23 08:44:26
Message-ID: 000801c3f9e9$3ec993c0$a2d9748c@thlgist2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?…
user_id=6364, username= e??e?°
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

Browse pgsql-sql by date

  From Date Subject
Next Message Sumita Biswas 2004-02-23 08:54:32 Re: Postgres DB
Previous Message Sumita Biswas 2004-02-23 08:33:05 EXECUTing QUERY: