我用的是php+mysql,插入中文是问号。
mysql的表建立如下CREATE TABLE IF NOT EXISTS `user` (
`ID` int(4) NOT NULL AUTO_INCREMENT,
`name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`departmet` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`sex` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
`acadamy` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
`garde` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
`marjor` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
`num` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
我同时在php里
header("Content-type: text/html; charset=utf-8");
$link=mysql_connect("localhost","name","password") or die("can't connect to the database");
mysql_query("SET NAMES 'UTF8'");
mysql_query("SET CHARACTER SET UTF8");
mysql_query("SET CHARACTER_SET_RESULTS=UTF8");
mysql_select_db("C278138",$link) or die("can't connect to the table");
还是插入不了,插入进去是问号,select出来也是问号,请问我哪里错了?
mysql的表建立如下CREATE TABLE IF NOT EXISTS `user` (
`ID` int(4) NOT NULL AUTO_INCREMENT,
`name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`departmet` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`sex` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
`acadamy` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
`garde` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
`marjor` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
`num` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
我同时在php里
header("Content-type: text/html; charset=utf-8");
$link=mysql_connect("localhost","name","password") or die("can't connect to the database");
mysql_query("SET NAMES 'UTF8'");
mysql_query("SET CHARACTER SET UTF8");
mysql_query("SET CHARACTER_SET_RESULTS=UTF8");
mysql_select_db("C278138",$link) or die("can't connect to the table");
还是插入不了,插入进去是问号,select出来也是问号,请问我哪里错了?
联系管理员看看吧.虚拟主机就是烦..或者你尝试将中文做一个编码转换 转换成gbk的,搞不好他就正常了.
————————————————————————————————
基于CSDN论坛提供的插件扩展功能,自己做了个签名档工具,分享给大家,欢迎技术交流 :)