+ -
当前位置:首页 → 问答吧 → mysql数据库的问题,大虾帮下啊

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);

作者: a345344164   发布时间: 2010-08-26

连接数据库时设置

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