|
HeidiSQL 에서 백업한 자료인데 한글이 깨져 나옵니다.
Mysql 서버에서 한글 설정을 'latin1' euckr' 로 바꾸어 보아도 여전히 한글이 제대로 나오질 않습니다.
복구할수 있는 방법이 없을까요?
백업자료 처음 일부를 첨부합니다.
//==================================================
# HeidiSQL Dump
# --------------------------------------------------------
# Database: dyou
# Server version: 4.1.12
# Server OS: pc-linux-gnu
# Target-Compatibility: MySQL 4.0
# Extended INSERTs: Y
# max_allowed_packet: 1048576
# HeidiSQL version: 3.0 Revision: 572
# --------------------------------------------------------
/*!40100 SET CHARACTER SET latin1*/;
#
# Database structure for database 'dyou'
#
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `dyou`;
USE `dyou`;
#
# Table structure for table 'ACCOUNT'
#
CREATE TABLE /*!32312 IF NOT EXISTS*/ `ACCOUNT` (
`id` int(11) NOT NULL default '0',
`account` int(1) NOT NULL default '0',
`account_nm` varchar(30) NOT NULL default '',
`account_desc` varchar(30) default NULL,
`userid` varchar(15) NOT NULL default '',
`use_yn` char(1) NOT NULL default 'Y',
`ip` varchar(15) NOT NULL default '',
`createdate` varchar(14) NOT NULL default '',
`updatedate` varchar(14) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=euckr COMMENT='????';
#
# Dumping data for table 'ACCOUNT'
#
/*!40000 ALTER TABLE `ACCOUNT` DISABLE KEYS*/;
LOCK TABLES `ACCOUNT` WRITE;
REPLACE INTO `ACCOUNT` (`id`, `account`, `account_nm`, `account_desc`, `userid`, `use_yn`, `ip`, `createdate`, `updatedate`) VALUES (1,2,'??','??','sitycoon','N','127.0.0.1','20080319001622','20080319001622'),
(2,1,'???','???','sitycoon','N','127.0.0.1','20080330100930','20080330102749'),
(3,2,'?????','?????','qudfks','Y','192.168.0.1','20090722113817','20090722160832');
UNLOCK TABLES;
/*!40000 ALTER TABLE `ACCOUNT` ENABLE KEYS*/;
|
