mysql数据库的问题,大虾帮下啊
时间:2010-08-26
来源:互联网
我今天将数据传在服务器上,开始的时候还是中文,可是过了一会就变成乱码了。后来我换了一个机器去传到服务器上,插入的数据居然中文都消失了 ,为什么啊 。大虾帮帮我啊 。
其中数据库的编码 是utf-8, 在本地的时候执行 也没问题 ,可是到了服务器是就出现乱码了,而且
部分数据库代码
CREATE TABLE `jos_ak_stats` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`description` varchar(255) NOT NULL,
`comment` longtext,
`backupstart` timestamp NOT NULL default '0000-00-00 00:00:00',
`backupend` timestamp NOT NULL default '0000-00-00 00:00:00',
`status` enum('run','fail','complete') NOT NULL default 'run',
`origin` enum('backend','frontend','cli') NOT NULL default 'backend',
`type` enum('full','dbonly','extradbonly','alldb','fileonly') NOT NULL default 'full',
`profile_id` bigint(20) NOT NULL default '1',
`archivename` longtext,
`absolute_path` longtext,
`multipart` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
--
-- 导出表中的数据 `jos_ak_stats`
--
INSERT INTO `jos_ak_stats` (`id`, `description`, `comment`, `backupstart`, `backupend`, `status`, `origin`, `type`, `profile_id`, `archivename`, `absolute_path`, `multipart`) VALUES
(7, 'Backup taken on 2010-06-11, 周五 03:12', '', '2010-06-11 03:12:45', '2010-06-11 03:16:11', 'complete', 'backend', 'full', 1, 'huarui-20100611-031245.jpa', 'E:/joomlabackup/huarui-20100611-031245.jpa', 0),
(8, 'Backup taken on 2010-06-18, 周五 06:34', '', '2010-06-18 06:35:20', '2010-06-18 06:41:56', 'complete', 'backend', 'full', 1, 'huarui-20100618-063520.jpa', 'E:/joomlabackup/huarui-20100618-063520.jpa', 0),
(9, 'Backup taken on 2010-06-28, 周一 03:49', '', '2010-06-28 03:49:42', '0000-00-00 00:00:00', 'complete', 'backend', 'full', 1, 'huarui-20100628-034942.jpa', 'E:/joomlabackup/huarui-20100628-034942.jpa', 0),
(10, 'Backup taken on 2010-07-30, 周五 05:35', '', '2010-07-30 05:36:13', '2010-07-30 05:40:00', 'complete', 'backend', 'full', 1, 'huarui-20100730-053613.jpa', 'E:/joomlabackup/huarui-20100730-053613.jpa', 0),
(11, 'Backup taken on 2010-08-02, 周一 04:45', '', '2010-08-02 04:46:05', '2010-08-02 04:51:13', 'complete', 'backend', 'full', 1, 'huarui-20100802-044605.jpa', 'E:/joomlabackup/huarui-20100802-044605.jpa', 0),
(12, 'Backup taken on 2010-08-02, 周一 05:12', '', '2010-08-02 05:12:51', '2010-08-02 05:14:51', 'complete', 'backend', 'full', 1, 'huarui-20100802-051251.jpa', 'E:/joomlabackup/huarui-20100802-051251.jpa', 0),
(13, 'Backup taken on 2010-08-03, 周二 13:05', '', '2010-08-03 13:06:07', '2010-08-03 13:07:39', 'complete', 'backend', 'full', 1, 'huarui-20100803-130607.jpa', 'E:/joomlabackup/huarui-20100803-130607.jpa', 0),
(14, 'Backup taken on 2010-08-04, 周三 04:36', '', '2010-08-04 04:36:26', '2010-08-04 04:38:51', 'complete', 'backend', 'full', 1, 'huarui-20100804-043626.jpa', 'E:/joomlabackup/huarui-20100804-043626.jpa', 0),
(15, 'Backup taken on 2010-08-05, 周四 10:18', '', '2010-08-05 10:20:22', '2010-08-05 10:23:31', 'complete', 'backend', 'full', 1, 'huarui-20100805-102022.jpa', 'E:/joomlabackup/huarui-20100805-102022.jpa', 0),
(16, 'Backup taken on 2010-08-12, 周四 12:53', '', '2010-08-12 12:53:48', '2010-08-12 12:55:33', 'complete', 'backend', 'full', 1, 'huarui-20100812-125348.jpa', 'E:/joomlabackup/huarui-20100812-125348.jpa', 0),
(17, 'Backup taken on 2010-08-13, 周五 03:07', '', '2010-08-13 03:08:05', '2010-08-13 03:09:52', 'complete', 'backend', 'full', 1, 'huarui-20100813-030805.jpa', 'E:/joomlabackup/huarui-20100813-030805.jpa', 0),
(18, 'Backup taken on 2010-08-19, 周四 01:09', '', '2010-08-19 01:09:38', '2010-08-19 01:11:28', 'complete', 'backend', 'full', 1, 'huarui-20100819-010938.jpa', 'E:/joomlabackup/huarui-20100819-010938.jpa', 0),
(19, 'Backup taken on 2010-08-23, 周一 10:26', '', '2010-08-23 02:26:46', '2010-08-23 02:31:48', 'complete', 'backend', 'full', 1, 'huarui-20100823-102646.jpa', 'E:/joomlabackup/huarui-20100823-102646.jpa', 0),
(20, 'Backup taken on 2010-08-23, 周一 10:55', '', '2010-08-23 02:55:37', '0000-00-00 00:00:00', 'complete', 'backend', 'full', 1, 'huarui-20100823-105537.jpa', 'E:/joomlabackup/huarui-20100823-105537.jpa', 0);
其中数据库的编码 是utf-8, 在本地的时候执行 也没问题 ,可是到了服务器是就出现乱码了,而且
部分数据库代码
CREATE TABLE `jos_ak_stats` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`description` varchar(255) NOT NULL,
`comment` longtext,
`backupstart` timestamp NOT NULL default '0000-00-00 00:00:00',
`backupend` timestamp NOT NULL default '0000-00-00 00:00:00',
`status` enum('run','fail','complete') NOT NULL default 'run',
`origin` enum('backend','frontend','cli') NOT NULL default 'backend',
`type` enum('full','dbonly','extradbonly','alldb','fileonly') NOT NULL default 'full',
`profile_id` bigint(20) NOT NULL default '1',
`archivename` longtext,
`absolute_path` longtext,
`multipart` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
--
-- 导出表中的数据 `jos_ak_stats`
--
INSERT INTO `jos_ak_stats` (`id`, `description`, `comment`, `backupstart`, `backupend`, `status`, `origin`, `type`, `profile_id`, `archivename`, `absolute_path`, `multipart`) VALUES
(7, 'Backup taken on 2010-06-11, 周五 03:12', '', '2010-06-11 03:12:45', '2010-06-11 03:16:11', 'complete', 'backend', 'full', 1, 'huarui-20100611-031245.jpa', 'E:/joomlabackup/huarui-20100611-031245.jpa', 0),
(8, 'Backup taken on 2010-06-18, 周五 06:34', '', '2010-06-18 06:35:20', '2010-06-18 06:41:56', 'complete', 'backend', 'full', 1, 'huarui-20100618-063520.jpa', 'E:/joomlabackup/huarui-20100618-063520.jpa', 0),
(9, 'Backup taken on 2010-06-28, 周一 03:49', '', '2010-06-28 03:49:42', '0000-00-00 00:00:00', 'complete', 'backend', 'full', 1, 'huarui-20100628-034942.jpa', 'E:/joomlabackup/huarui-20100628-034942.jpa', 0),
(10, 'Backup taken on 2010-07-30, 周五 05:35', '', '2010-07-30 05:36:13', '2010-07-30 05:40:00', 'complete', 'backend', 'full', 1, 'huarui-20100730-053613.jpa', 'E:/joomlabackup/huarui-20100730-053613.jpa', 0),
(11, 'Backup taken on 2010-08-02, 周一 04:45', '', '2010-08-02 04:46:05', '2010-08-02 04:51:13', 'complete', 'backend', 'full', 1, 'huarui-20100802-044605.jpa', 'E:/joomlabackup/huarui-20100802-044605.jpa', 0),
(12, 'Backup taken on 2010-08-02, 周一 05:12', '', '2010-08-02 05:12:51', '2010-08-02 05:14:51', 'complete', 'backend', 'full', 1, 'huarui-20100802-051251.jpa', 'E:/joomlabackup/huarui-20100802-051251.jpa', 0),
(13, 'Backup taken on 2010-08-03, 周二 13:05', '', '2010-08-03 13:06:07', '2010-08-03 13:07:39', 'complete', 'backend', 'full', 1, 'huarui-20100803-130607.jpa', 'E:/joomlabackup/huarui-20100803-130607.jpa', 0),
(14, 'Backup taken on 2010-08-04, 周三 04:36', '', '2010-08-04 04:36:26', '2010-08-04 04:38:51', 'complete', 'backend', 'full', 1, 'huarui-20100804-043626.jpa', 'E:/joomlabackup/huarui-20100804-043626.jpa', 0),
(15, 'Backup taken on 2010-08-05, 周四 10:18', '', '2010-08-05 10:20:22', '2010-08-05 10:23:31', 'complete', 'backend', 'full', 1, 'huarui-20100805-102022.jpa', 'E:/joomlabackup/huarui-20100805-102022.jpa', 0),
(16, 'Backup taken on 2010-08-12, 周四 12:53', '', '2010-08-12 12:53:48', '2010-08-12 12:55:33', 'complete', 'backend', 'full', 1, 'huarui-20100812-125348.jpa', 'E:/joomlabackup/huarui-20100812-125348.jpa', 0),
(17, 'Backup taken on 2010-08-13, 周五 03:07', '', '2010-08-13 03:08:05', '2010-08-13 03:09:52', 'complete', 'backend', 'full', 1, 'huarui-20100813-030805.jpa', 'E:/joomlabackup/huarui-20100813-030805.jpa', 0),
(18, 'Backup taken on 2010-08-19, 周四 01:09', '', '2010-08-19 01:09:38', '2010-08-19 01:11:28', 'complete', 'backend', 'full', 1, 'huarui-20100819-010938.jpa', 'E:/joomlabackup/huarui-20100819-010938.jpa', 0),
(19, 'Backup taken on 2010-08-23, 周一 10:26', '', '2010-08-23 02:26:46', '2010-08-23 02:31:48', 'complete', 'backend', 'full', 1, 'huarui-20100823-102646.jpa', 'E:/joomlabackup/huarui-20100823-102646.jpa', 0),
(20, 'Backup taken on 2010-08-23, 周一 10:55', '', '2010-08-23 02:55:37', '0000-00-00 00:00:00', 'complete', 'backend', 'full', 1, 'huarui-20100823-105537.jpa', 'E:/joomlabackup/huarui-20100823-105537.jpa', 0);
作者: a345344164 发布时间: 2010-08-26
连接数据库时设置
mysql_query('SET NAMES UTF-8'); //设置数据库编码
如果数据库编码已经设置还是有总是,那就看一下数据库校对是什么编码
mysql_query('SET NAMES UTF-8'); //设置数据库编码
如果数据库编码已经设置还是有总是,那就看一下数据库校对是什么编码
作者: mijian 发布时间: 2010-08-26
楼上,你说的都试过了啊。
作者: a345344164 发布时间: 2010-08-26
qq群:网站技术探讨30120161
作者: 27025011 发布时间: 2010-08-26
沙发~~~学习下
作者: bread 发布时间: 2010-08-26
肯定是 三者之间的 编码不对
数据库的 页面的 查询 你看看这三个 是否一致
数据库的 页面的 查询 你看看这三个 是否一致
作者: jerrymsj 发布时间: 2010-08-26
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28