Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group