db->fetch_all($sql); foreach ($cms_arr as $v){ if($v['Collation'] != 'utf8mb4_general_ci'){ echo $v['Name'].''; $sql = "ALTER TABLE {$v['Name']} CONVERT TO CHARACTER SET utf8mb4 COLLATE">

学校源码企业政府漫画新闻自适应免费收费

您当前的位置：首页 > 建站资讯 > 批量修改数据库所有数据表的字符集

建站资讯

批量修改数据库所有数据表的字符集

来源：帝国CMS模板网作者：初遇时间：2026-07-05

浏览：25 收藏点赞(0)

简介：function collation() { $sql = "show table status"; $cms_arr = $this->db->fetch_all($sql); foreach ($cms_arr as $v){ if($v['Collation'] != 'utf8mb4_general_ci'){ echo $v['Name'].''; $sql = "ALTER TABLE {$v['Name']} CONVERT TO CHARACTER SET utf8mb4 COLLATE

function collation()
{

    $sql = "show table status";
    $cms_arr = $this->db->fetch_all($sql);
    foreach ($cms_arr as $v){
        if($v['Collation'] != 'utf8mb4_general_ci'){
            echo $v['Name'].'<br/>';
            $sql = "ALTER TABLE {$v['Name']} CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;";
            $this->db->fetch_first($sql);
        }

    }
    exit('ok');
}