MySQL?phpMyAdmin???UTF8?????????
???????????????????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
phpMyAdmin???2.6.1 rc-1
MySQL???4.1.8-nt
?????Appserv - Win32
????????big5
???MySQL????latin1
phpMyAdmin?????????????????
?????????????????????????????????????phpMyAdmin???????????????????????????????????????2.5.6????big5????????????????????phpMyAdmin????UTF-8????????????
?????????????????????????????????????????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???????????????????????????????????????????
?????????Appserv???????Linux?????MySQL??????????????????????latin1??????UTF-8?????????????????php?????????????UTF-8?????latin1????????????????????latin1?????????phpMyAdmin??????????????????
?UTF-8???????????
?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?
Win32 - Appserv????
?Windows?????MySQL????my.ini????????c:/window ?????????????????????latin1??utf8?
??????MySQL?????
???phpBB2??????db.php??60????????????MySQL??UTF-8????????
?????UTF-8????MySQL???latin1?????????????????????????62???????????????????????????????????????????????
???UTF-8???????????UTF-8????????????????????latin1????UTF8?????latin1?????????????UTF-8??????????UTF-8??????????????????????????????????????????
???UTF-8???????????????????phpMyAdmin????????????UTF-8???????latin1????????????????????????????????????????????????????????????????????????????????????????????
?????????????????????????UTF-8??????????latin1????????????????UTF-8??????????phpMyAdmin??UTF-8???????????????????????MySQL??????UTF-8?????????????UTF-8????????????
????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
???????????????DOS????????????????
????
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