??phpmyadmin????latin1 big5 ???mysql???? utf8

星期三, 2nd 九月 2009

??phpmyadmin???????big5?????utf-8

??????????????????big5??????\??????????????????

  1. ?phpmyadmin????????????latin1???????????????????4.0??mysql????????4.1????mysql??phpmyadmin???utf-8??, ??????phpmyadmin????big5?utf-8, ???big5??, ????????big5????.??????database.sql
  2. ???????? sql ????????? ??”DEFAULT CHARSET=latin1″ ?”DEFAULT CHARSET=utf8″??
  3. ????big5?utf-8??????, ?big5?database.sql?????utf-8??, notepad++?????????, ???????????->???utf-8???(???BOM)??
  4. big5???????????????, ????????????????\ ?ex ?\ ??????????????\??, ?????utf8??????????????\??????????????????????
    ?\\
    ?\\
    ?\\
    ?\\
    ?\\
    ?\\
    ?\\
    ?\\
    ?\\
    ?\\
    ?\\
  5. ?phpMyadmin???MySQL ???: UTF-8 Unicode (utf8)
  6. phpMyadmin???MySQL ???? ? utf8_general_ci
  7. ???????phpmyadmin?????????????
  8. ??????????????????
    $this->query(”SET NAMES ‘utf8′” );