mysql 字符集研究与测试续

   这篇博文主要是对鸟哥一篇关于mysql字符集实验的测试验证，为保证字符集设置不被改变，我主要用php  脚本测试；下面是mysql表结构与php的脚本

show create table niaoge_latin1;
+---------------+--------------------------------------------------------------
---------------------------------------+
| Table         | Create Table
                                       |
+---------------+--------------------------------------------------------------
---------------------------------------+
| niaoge_latin1 | CREATE TABLE `niaoge_latin1` (
  `name` char(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+---------------+--------------------------------------------------------------
---------------------------------------+
1 row in set (0.00 sec)

show create table niaoge_utf8;
+-------------+----------------------------------------------------------------
---------------------------------+
| Table       | Create Table
                                 |
+-------------+----------------------------------------------------------------
---------------------------------+
| niaoge_utf8 | CREATE TABLE `niaoge_utf8` (
  `name` char(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+-------------+----------------------------------------------------------------
---------------------------------+
1 row in set (0.00 sec)
$con = mysql_connect("localhost","root","123456");

$dbs = mysql_select_db("t", $con);

$charset = "set character_set_connection=latin1,character_set_results=latin1,character_set_client=latin1";
//$charset = "set character_set_connection=utf8,character_set_results=utf8,character_set_client=utf8";
mysql_query($charset,$con);

$sql = "insert into niaoge_utf8(name) values('刘 晓 波')";
//$sql = "select * from niaoge_utf8";
$res = mysql_query($sql,$con);

//$rest = mysql_fetch_assoc($res);

//print_r($rest);

 
$con = mysql_connect("localhost","root","123456");

$dbs = mysql_select_db("t", $con);

//$charset = "set character_set_connection=latin1,character_set_results=latin1,character_set_client=latin1";
$charset = "set character_set_connection=utf8,character_set_results=utf8,character_set_client=utf8";
mysql_query($charset,$con);

//$sql = "insert into niaoge_utf8(name) values('刘 晓 波')";
$sql = "select * from niaoge_utf8";
$res = mysql_query($sql,$con);

$rest = mysql_fetch_assoc($res);

print_r($rest);

 
Array ( [name] => 氓藛藴忙鈩⑩€溍β陈� ) 
   
<?php

$con = mysql_connect("localhost","root","123456");

$dbs = mysql_select_db("t", $con);

//$charset = "set character_set_connection=latin1,character_set_results=latin1,character_set_client=latin1";
$charset = "set character_set_connection=utf8,character_set_results=utf8,character_set_client=utf8";
mysql_query($charset,$con);

$sql = "insert into niaoge_latin1(name) values('***')";
//$sql = "select * from niaoge_latin1";
$res = mysql_query($sql,$con);

//$rest = mysql_fetch_assoc($res);

//print_r($rest);
 
<?php

$con = mysql_connect("localhost","root","123456");

$dbs = mysql_select_db("t", $con);
 

 
    下面附上鸟哥的解释