???????????????????MySQL??????????????????????????????????????????????????????????????????????????????????????????????????????”UTF-8????”????

????????”??”?????PHP??????MySQL????????????????phpMyAdmin????MySQL?????????phpMyAdmin??????????????????????????phpMyAdmin?????????????????????

 

??(1) phpMyAdmin???????????????

???? 

phpMyAdmin???2.5.6
MySQL???4.1.8-nt
?????Appserv - Win32
????????big5
???MySQL????latin1

mysql2.gif

phpMyAdmin???2.6.1 rc-1
MySQL???4.1.8-nt
?????Appserv - Win32
????????big5
???MySQL????latin1

mysql1.gif

phpMyAdmin?????????????????

?????????????????????????????????????phpMyAdmin???????????????????????????????????????2.5.6????big5????????????????????phpMyAdmin????UTF-8????????????

mysql3.gif

?????????????????????????????????????????phpMyAdmin????????????????????UTF-8???????????

??(2) ??UTF-8????????????phpMyAdmin????????

???? 

phpMyAdmin???2.6.1 rc-1
MySQL???4.1.8-nt
?????Appserv - Win32
????????UTF-8
???MySQL????UTF-8

??????????MySQL???????????????”??”?????????phpMyAdmin????UTF-8??????????????????????????????????????????? 

mysql4.gif

?????????Appserv???????Linux?????MySQL??????????????????????latin1??????UTF-8?????????????????php?????????????UTF-8?????latin1????????????????????latin1?????????phpMyAdmin??????????????????

?UTF-8???????????

mysql5.gif

?UTF-8???????????????UTF-8???????????????????????UTF-8???????????????UTF-8????????????????????MySQL???????????latin1?????UTF-8?????latin1??????????????????????????UTF-8?????????latin1?????????????????????????????????????????????????

????????????phpbb????MySQL?????latin1?????”??”?”??”?UTF-8????

?latin1????????????phpMyAdmin?????????????????????utf8_general_ci?utf8_unicode_ci?latin1_swedish_ci?????????????????????????????

??????phpMyAdmin???UTF-8???????????????????

??MySQL?????????
Linux?Unix-like??

?? /etc/my.cnf ????????MySQL????????????????vbird?WWW???#MySQL???????????????????????????????????MySQL???latin1????????UTF-8?

mysql6.gif

Win32 - Appserv????

?Windows?????MySQL????my.ini????????c:/window ?????????????????????latin1??utf8?

??????MySQL?????

???phpBB2??????db.php??60????????????MySQL??UTF-8????????

mysql71.gif

?????UTF-8????MySQL???latin1?????????????????????????62???????????????????????????????????????????????

mysql8.gif

???UTF-8???????????UTF-8????????????????????latin1????UTF8?????latin1?????????????UTF-8??????????UTF-8??????????????????????????????????????????

mysql9.gif

???UTF-8???????????????????phpMyAdmin????????????UTF-8???????latin1????????????????????????????????????????????????????????????????????????????????????????????

mysql10.gif

?????????????????????????UTF-8??????????latin1????????????????UTF-8??????????phpMyAdmin??UTF-8???????????????????????MySQL??????UTF-8?????????????UTF-8????????????

mysql11.gif

????MySQL??????UTF-8?????????????????

??(3) ??UTF-8????????Hosting??mysqldump????,mysql?????????MySQL 4.x???????????

???????????????????????Hosting???VPS???????????????????????????????????????????????????????????????????????????????????????????????????MySQL???????big5?UTF-8?????????????????

?mysqldump?????????????????????????????????????????????????UTF-8???????????????UTF-8???????????????latin1??????mysql???????????

??????????latin1??????????latin1?????mysqldump?????mysql????????????????????????????????UTF-8???????????????????????????????????????Mysql????????????????MySQL??4.1.8(??????latin1)??????mysqldump??????????MySQL???5(??????latin1)??mysql???????????????????????????????????????

????????????????????????????????????????????SQL????????????????????????????????????????????????????????????????????????MySQL????????????????????????????????????

?????????????MySQL?????4.1.8???5??????????????????????????????????????????????

??

MySQL???????

??????Appserv???????????? - ?? - ??: cmd

mysql12.gif

???????????????DOS????????????????

mysql13.gif 

????

mysqldump - -opt database > backup-file.sql

??- -opt (????-?????????????????????????) ???????????????database???????????????? backup-file.sql??????????????????Linux????????

MySQL??????????

????

mysql database < backup-file.sql

  

??

??????????????????????????????????????????????????????????????????????????????????????????????6????????????????????10??????????1000???????????10000???????? ?????????30???????????????????????

???????
AdSenseor?????
???http://www.adsenseor.com