Евгений Неверов (Все сообщения пользователя)

CREATE TEMPORARY TABLE b_user_access_check_tmp (USER_ID int, PROVIDER_ID varchar(50)) ENGINE=InnoDB;
INS ERT IN TO b_user_access_check_tmp SEL ECT DISTINCT * FR OM b_user_access_check;
DELETE FROM b_user_access_check;
INS ERT IN TO b_user_access_check SEL ECT * FR OM b_user_access_check_tmp;

class irkutsk350ru extends CModule {
  public $MODULE_ID = 'irkutsk350ru';

  public $MODULE_VERSION = '1.0';
  public $MODULE_VERSION_DATE = '2011-09-06';
  ...
}

$needCollation = 'utf8_general_ci'; // укажите здесь нужную кодировку

$res = $DB->Query('SHOW TABLE STATUS');
while($ts = $res->fetch()) {
    if ($ts['Collation'] != $needCollation) $DB->Query('ALTER TABLE `' . $ts['Name'] . '` DEFAULT CHARACTER SET utf8 COLLATE ' . $needCollation);

    $r2 = $DB->Query('SHOW FULL COLUMNS FROM ' . $ts['Name'] . ' WHERE Collation IS NOT NULL');
    while($col = $r2->fetch()) {
   if ($col['Collation'] != $needCollation) $DB->Query('ALTER TABLE `' . $ts['Name'] . '` CHANGE `' . $col['Field'] . '` `' . $col['Field'] . '` ' . $col['Type'] . ' CHARACTER SET utf8 COLLATE ' . $needCollation . ($col['Null'] == 'NO' ? ' NOT' : '') . ' NULL');
    }
}