对于语言编码，MySQL都为我们做了什么

<?php

    header("Content-type:text/html;Charset=UTF-8;");

    $link=mysql_connect("localhost","root","123456") or die("无法连接服务!");

    mysql_select_db("codegbk",$link) or die("数据库无法选择");

    mysql_query("set names utf8");

    $rs = mysql_query("select *from user",$link);

    

     $sql = "insert into user values(default,'测试乱码')";

     mysql_query($sql);

    while($row = mysql_fetch_array($rs)){

   	echo $row["username"]."<br/>";

    }

?>

mysql_connect();

mysql_select_db('test');

mysql_query('DROP TABLE IF EXISTS `mb`);

$sql = <<< SQL

CREATE TABLE 	`mb` (

  `ch` varchar(10) NOT NULL,

  `val` varchar(50) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=gbk;

SQL;

mysql_query($sql);



function save($charset, $text) {

  mysql_query("set names $charset");

  mysql_query("insert into mb values ('$charset', '$text')");

}



function load($charset) {

  mysql_query("set names $charset") or die(mysql_error());

  $rs = mysql_query('select * from mb');

  while($row = mysql_fetch_assoc($rs)) {

    list($hex) = unpack('H*0', $row[val]);

    echo "$charset $row[ch] : $row[val] $hex<br>";

  }

}



$s = "漢字";



save('gbk', $s);

save('utf8', iconv('gbk', 'utf-8', $s));

save('big5', iconv('gbk', 'big5', $s));



load('gbk');

load('utf8');

load('big5');

function binhex($str) {

	$hex = "";    

	$i = 0;    

	do {        

		$hex .= sprintf("%02x", ord($str{$i}));        

		$i++;    

	} 

	while ($i < strlen($str));    

	return $hex;

}