多谢了,稍后改一下试试。<br><br><div><span class="gmail_quote">On 10/28/07, <b class="gmail_sendername">Jeff Pang</b> <<a href="mailto:pangj@earthlink.net">pangj@earthlink.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 10/28/07, Jesse Lee <<a href="mailto:cdrplum@gmail.com">cdrplum@gmail.com</a>> wrote:<br>>有一个使用 Jabber 协议的聊天程序,通过客户端发送的信息存到 MySQL 数据库后中文文字变成了这样的:<br>> &#x4FE1;&#x606F;&#x592A;&#x77ED;<br>> 上面对应的是 "信息太短" 四个字,使用的都是 UTF8 编码,在网页上显示也是正常的,这样是否正常呢?
<br>> 能否变成直接的中文?在 phpmyadmin 中看到中文?<br>><br><br>Before inserting into database,you will add a set names statement:<br><br>$sth = $dbh->prepare("set names 'utf8'");<br>$sth->execute();<br><br>
Also you'd better translate the values from gb* to utf-8 before inserting.<br><br>use Encode;<br>$cn_characters = "信息太短";<br>$cn_characters = encode("utf8",decode("gb2312",$cn_characters));
<br><br>then in sql,<br><br>insert into table (cn_character_column) values ($cn_characters);<br>_______________________________________________<br>China-pm mailing list<br><a href="mailto:China-pm@pm.org">China-pm@pm.org</a>
<br><a href="http://mail.pm.org/mailman/listinfo/china-pm">http://mail.pm.org/mailman/listinfo/china-pm</a></blockquote></div><br><br clear="all"><br>-- <br><a href="<a href="http://www.digbuzz.com/">http://www.digbuzz.com/
</a>" target="_blank"><img src="<a href="http://www.digbuzz.com/images/btns/468x60-1.gif">http://www.digbuzz.com/images/btns/468x60-1.gif</a>" width="468" height="60" border="0" /></a>
<br><br /><br> <span style="font-size: 12px; font-family: Arial, Helvetica, sans-serif;">我挖网 <a href="<a href="http://www.digbuzz.com/">http://www.digbuzz.com/</a>" target="_blank">
<a href="http://www.digbuzz.com">www.digbuzz.com</a></a> - Web 2.0 用户挖新闻社区</span>