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='????????????';这里有点问题,是不是需要将汉字转换一下编码才行啊.
解决方案 »
- 单选框
- 。。。。。。。。。来一个简单的,基础的问题。。。。。。。。。。。
- 阿里巴巴商人论坛的市场运作体验分析4
- php对ajax post过来的数据的处理
- 自动填充序列的问题
- 能否提供一个可以缩图,并且在缩图的上面打上字,并且输出到某个指定文件夹里面
- 如何在显示PHP变量的时候,遇到网址自动加超级链接?
- 怎么样用文本实现http://netyeah.51.net/中的最新消息 最新文章 论坛帖子 3个版块.具体代码怎么写?
- 如何把一个PHP文件解密? Zend 2000112001 1 943 2501 x??
- PHP需要多少时间掌握?
- 数据总是少一条!为什么会这样?请帮忙!
- 问一个php正则的问题 请高手帮忙~
2, 用最新的mysql客户端和服务端
之后在插入数据