can't support utf-8?

Help
2006-08-30
2013-05-30
  • Nobody/Anonymous

    hi,

    My server is Apache/2.0.53 (Fedora),
    Mysql is 4.1.20
    PHP is 5.0.4,

    After backup UTF-8 DB, i view the sql and find that all data shows ????????

    Whether phpMyBackupPro support UTF-8?

     
    • Nobody/Anonymous

      I think i find out the reason.

      In phpMyAdmin, when i export utf-8 DB, i have to select "UTF-8" in the field of "Character set of the file", otherwise the db can't dump correctly.

      In phpMyBackupPro, it seems no such selection.

       
    • Nobody/Anonymous

      I am having the same problem.

      Getting the question marks..
      On my php scripts I use:

      mysql_query("SET NAMES utf8");   
      mb_internal_encoding("UTF-8");   

      To handle the encoding correctly.

      MyBackupPro seems like a good program so I patched it:
      Using dreamweaver I searched for "mysql_connect" in every php file, then added those two lines after it.

      The backup and import now works like a charm.

       
    • Nobody/Anonymous

      In order to view the DB info in
      admin panel --> import, you need to edit:

      open
      get_file.php

      find
      "htmlentities"

      change to
      "htmlspecialchars"

       
  • vahid

    vahid - 2013-05-24

    Hi,
    To future friends who face problem with PhpMyBackupPro:
    Open file < functions.inc.php > in the main directory of PMB and  simply find functions bellow, and replace the code:

    //implement core hack to support UTF8 Databases
    function PMBP_mysql_connect() {
    global $CONF;
    $res = @mysql_connect($CONF,$CONF,$CONF);
    if($res) {
    PMBP_set_character_set();
    }
    return $res;
    }

    function PMBP_set_character_set() {
    $characterSet = 'utf8';//PMBP_get_character_set();
    @mysql_query("set names " . $characterSet);
    return $characterSet;
    }

    best wishes
    Vahid Moslemi

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks