CREATE TABLE `my_info` (
`id` bigint(200) NOT NULL auto_increment,
`pw_id` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`gonghao` varchar(50) NOT NULL default '',
`domain` varchar(100) character set utf8 collate utf8_unicode_ci default NULL,
`name` varchar(30) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`sex` tinyint(1) unsigned default NULL,
`mail_address` varchar(50) character set utf8 collate utf8_unicode_ci default NULL,
`year` bigint(4) unsigned default NULL,
`month` tinyint(2) unsigned default NULL,
`day` tinyint(2) unsigned default NULL,
`corp_name` varchar(80) character set utf8 collate utf8_unicode_ci default NULL,
`department` varchar(80) character set utf8 collate utf8_unicode_ci default NULL,
`address` varchar(90) character set utf8 collate utf8_unicode_ci default NULL,
`home_phone` varchar(13) character set utf8 collate utf8_unicode_ci default NULL,
`mobile` varchar(13) character set utf8 collate utf8_unicode_ci default NULL,
`re` varchar(200) character set utf8 collate utf8_unicode_ci default NULL,
`public` tinyint(1) unsigned NOT NULL default '1',
`depid` int(10) NOT NULL default '0',
PRIMARY KEY (`id`,`pw_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='????????????';
这是数据库的创建文件,感觉到`name` varchar(30) character set utf8 collate utf8_unicode_ci NOT NULL default '',
ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='????????????';这里有点问题,是不是需要将汉字转换一下编码才行啊.
`id` bigint(200) NOT NULL auto_increment,
`pw_id` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`gonghao` varchar(50) NOT NULL default '',
`domain` varchar(100) character set utf8 collate utf8_unicode_ci default NULL,
`name` varchar(30) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`sex` tinyint(1) unsigned default NULL,
`mail_address` varchar(50) character set utf8 collate utf8_unicode_ci default NULL,
`year` bigint(4) unsigned default NULL,
`month` tinyint(2) unsigned default NULL,
`day` tinyint(2) unsigned default NULL,
`corp_name` varchar(80) character set utf8 collate utf8_unicode_ci default NULL,
`department` varchar(80) character set utf8 collate utf8_unicode_ci default NULL,
`address` varchar(90) character set utf8 collate utf8_unicode_ci default NULL,
`home_phone` varchar(13) character set utf8 collate utf8_unicode_ci default NULL,
`mobile` varchar(13) character set utf8 collate utf8_unicode_ci default NULL,
`re` varchar(200) character set utf8 collate utf8_unicode_ci default NULL,
`public` tinyint(1) unsigned NOT NULL default '1',
`depid` int(10) NOT NULL default '0',
PRIMARY KEY (`id`,`pw_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='????????????';
这是数据库的创建文件,感觉到`name` varchar(30) character set utf8 collate utf8_unicode_ci NOT NULL default '',
ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='????????????';这里有点问题,是不是需要将汉字转换一下编码才行啊.
解决方案 »
- 网站为 utf8 版本,是不是指:数据库编码是utf8 的,同时源文件必须以 utf8 格式保存呢?
- 请教如何调用类里COOKIE值
- 这个语句在MYSQL中报错。。不知哪里错了。。。
- 如何在站内实现google那个的搜索结果
- post textarea图文信息到后台,但是后台无法提取到图片数组,求解????
- 访问apache里的资源直接下载其文件
- 关于mysql 的 load data local infile
- 有谁做过可以发短信的站点吗?有什么好的代码可以参考吗?
- 中文显示问题!!!
- 那位大哥帮帮忙啊,请问哪有下PHP编的联系人地址本的代码啊??(Mysql支持)急需啊~~
- 数据总是少一条!为什么会这样?请帮忙!
- 问一个php正则的问题 请高手帮忙~
2, 用最新的mysql客户端和服务端
之后在插入数据