- 论坛徽章:
- 0
|
mysql是4.0.17的
| character sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis |
网上说mysql是4.1及以后版本才有的字符集的概念
那么我就不能在utf-8编码的页面显示数据库中的中文数据了吗？
源码如下:
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- </head>
- <body>
- <?php
- $conn=mysql_connect("localhost","root","");
- mysql_select_db("library",$conn);
- $sql="select * from mgr";
- $res_list=mysql_query($sql);
- for($i=0;$i<mysql_num_rows($res_list);$i++){
- $res=mysql_fetch_array($res_list);
- echo "<div align='center'>";
- foreach($res as $k=>$v){
- echo $v." | ";
- }
- echo "</div>";
- }
- mysql_close($conn);
- ?>
- <div>工作队</div>
- </body>
- </html>
显示如下：
- 1 | 1 | wabomo | wabomo | 110110 | 110110 | ͵??ģ | ͵??ģ | M | M | 13637424875 | 13637424875 | ѧɺ֤ | ѧɺ֤ | 085842 | 085842 | 1 | 1 |
- 2 | 2 | floodking | floodking | 120120 | 120120 | ͵?馮bsp;| ͵?馮bsp;| M | M | 51642315 | 51642315 | Ξ | Ξ | Ξ | Ξ | 1 | 1 |
- 3 | 3 | lilac | lilac | 110110 | 110110 | NB | NB | F | F | 45615545 | 45615545 | ɭ?ݖ? | ɭ?ݖ? | 431103198708180636 | 431103198708180636 | 1 | 1 |
- 4 | 4 | nonameAA | nonameAA | 000 | 000 | Ξû | Ξû | M | M | 12354250 | 12354250 | ѧɺ֤ | ѧɺ֤ | 085847 | 085847 | 1 | 1 |
- 13 | 13 | test | test | test | test | test | test | M | M | test | test | test | test | test | test | 0 | 0 |
- 15 | 15 | kkk | kkk | 110110 | 110110 | k | k | M | M | 123 | 123 | 123 | 123 | 123 | 123 | 1 | 1 |
- 工作队
[ 本帖最后由 wabomo 于 2009-4-1 14:45 编辑 ] |
|
免费注册
发表于 2009-04-01 14:43
