Ȩ
ȣ
()
(ű)
/û
FAQ
ٶ
070-8260-2526
9 ~ 6
352-0331-1626-83
:ũڸ
ֹ
Ȩ > > ֹ
ȸ
7277
mysql latin1 DB utf8 ٲٱ
mysql latin1 DB utf8 ٲٱ | α
2011.11.11 11:54
Ӹ
(wolfaou)
http://cafe.naver.com/jnsinc/85
: latin1 DB utf8 ٲٱ
1. mysqldump -u userid -ppasswd --default-character-set=utf8 dbname tablename > dbname.tablename.sql ;
dbname.tablename.sql ÷ 븸 Ű
ÿ ݵ ٸ̸ Ҷ Ͽɼ utf8 մϴ.
2. Ű mysql Ŵ ̺ Ѵ. ̶ DEFAULT CHARSET=utf8 ɼ ֽϴ.
Ǯ:
CREATE TABLE `tablename` (
`num` int(11) NOT NULL AUTO_INCREMENT,
......
PRIMARY KEY (`num`),
KEY `p_no` (`p_no`),
KEY `p_no_2` (`p_no`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
3. Ͽ mysql մϴ.
mysql -u userid -ppasswd dbname ;
4. ϴ. Ʒ ɾ
set GLOBAL max_allowed_packet= 1024*1024*32 ;
5. Ʈ Դϴ.
set names utf8 ;
source C:Users1dbname.tablename.sql
ֹ
¶λ
Ʈ