sql server2000数据导入mysql问题 请教大虾,表导入后,数据要么就丢失,要么就乱码(数据也丢失很多),怎么解决?在线等~~谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 请教hy2003fly() 首先你mysql的字符集应该设置成这样:mysql> show variables like '%char%';+--------------------------+--------------------------+| Variable_name | Value |+--------------------------+--------------------------+| character_set_client | utf8 || character_set_connection | utf8 || character_set_database | utf8 || character_set_filesystem | binary || character_set_results | utf8 || character_set_server | utf8 || character_set_system | utf8 || character_sets_dir | d:\mysql\share\charsets\ |+--------------------------+--------------------------+8 rows in set (0.08 sec)我按照你说的敲入 mysql> show variables like '%char%';显示出来的+--------------------------+--------------------------+| Variable_name | Value |+--------------------------+--------------------------+| character_set_client | gb2312 || character_set_connection | gb2312 || character_set_database | gb2312 || character_set_filesystem | binary || character_set_results | gb2312 || character_set_server | gb2312 || character_set_system | utf8 || character_sets_dir | d:\mysql\share\charsets\ |+--------------------------+--------------------------+8 rows in set (0.08 sec)何解?能告知原因吗? 上面的字符集设置已经可以了.使用mysql marigation tool kit这个图形工具来导过去,导的过程中要注意设置字集集的参数,否则会出现乱码.存储过程,我没有导过不清楚会有什么结果. 请教SQLyog的,数据库主机地址怎么填?不是本地的 我今天上传了个PHP程序到我的空间,出现下面错误,请大家帮忙解决下!! 数据库内表过多,会有什么影响? Solaris下如何使用jsp和mysql搭配 mysql数据导出问题(在线) 一个数据转换问题 如何从数据库查询出比较日期字段,取得离现在最近的日期?谢了 如何在进行表更新操作时把表锁定,有这样的命令么? 急!! 同一张表,根据不同用户展示不同数据,该如何做呢? 本地机器如何判断远程机器是否安装MYSQL,如果安装了如何检测某个数据库存在 limit问题 如何将mysql数据库里的用户密码重置为MD5加密的密码
首先你mysql的字符集应该设置成这样:
mysql> show variables like '%char%';
+--------------------------+--------------------------+
| Variable_name | Value |
+--------------------------+--------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | d:\mysql\share\charsets\ |
+--------------------------+--------------------------+
8 rows in set (0.08 sec)我按照你说的敲入 mysql> show variables like '%char%';
显示出来的
+--------------------------+--------------------------+
| Variable_name | Value |
+--------------------------+--------------------------+
| character_set_client | gb2312 |
| character_set_connection | gb2312 |
| character_set_database | gb2312 |
| character_set_filesystem | binary |
| character_set_results | gb2312 |
| character_set_server | gb2312 |
| character_set_system | utf8 |
| character_sets_dir | d:\mysql\share\charsets\ |
+--------------------------+--------------------------+
8 rows in set (0.08 sec)何解?能告知原因吗?