这篇博文主要是对鸟哥一篇关于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);
下面附上鸟哥的解释
相关推荐
设置mysql字符集 mysql 乱码
mysql 字符集 转换
linux修改mysql字符集 linux修改mysql字符集
查看mysql字符集MySQL 乱码的根源是的 MySQL 字符
关于MySQL字符集查看与修改; MySQL的字符集支持(Character Set Support)有两个方面: 字符集(Character set)和排序方式(Collation)。 MySQL对于字符集的支持细化到四个层次: 服务器(server),数据库(database),...
精通MySQL字符集与校对集,再也不会为乱码而心烦意乱了
mysql数据库,表 ,字段的字符集设置
mysql字符集和校对集
mysql字符集查看以及修改
MYSQL修改字符集默认问题
设定mysql字符集解决终端乱码设定mysql字符集解决终端乱码
Mysql字符集
linux下设置mysql字符集为UTF-8以及mysql重启
MYSQL字符集乱码的解决 在命令行下,以及从网页取出来就不会出现乱码
Linux下修改MySQL字符集 1.查找MySQL的cnf文件的位置 find / -iname '*.cnf' -print /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-small.cnf /usr/share/mysql/...
mysql数据库互相转换及同步工具-MySQL_MySQL字符集互转
安装完的MySQL的默认字符集为 latin1 ,为了要将其字符集改为用户所需要的(比如utf8),就必须改其相关的配置文件;由于linux下MySQL的默认安装目录分布在不同的文件下;不像windows一样放在同一目录下,只需修改其中...
Mysql数据库乱码 问题彻底解决 针对JAVA
MySQL 批量修改SCHEMA下所有数据表的编码及字符集
Mysql字符集设置原理及常见问题解决