BITRIX utf8mb4

Файл: after_connect.php

//$DB->Query("SET NAMES 'utf8'");
//$DB->Query("SET collation_connection = 'utf8_unicode_ci'");

$DB->Query("SET NAMES 'utf8mb4'");
$DB->Query('SET collation_connection = "utf8mb4_unicode_ci"');

Файл: after_connect_d7.php

//$connection->queryExecute("SET NAMES 'utf8'");
//$connection->queryExecute('SET collation_connection = "utf8_unicode_ci"');

$connection->queryExecute("SET NAMES 'utf8mb4'");
$connection->queryExecute('SET collation_connection = "utf8mb4_unicode_ci"');

Файл: bitrix/modules/main/classes/general/site_checker.php

if (defined('BX_UTF') && BX_UTF === true)
{
   if ($character_set_connection != 'utf8mb4')
      $strError = GetMessage("SC_CONNECTION_CHARSET_WRONG", array('#VAL#' => 'utf8', '#VAL1#' => $character_set_connection));
   elseif ($collation_connection != 'utf8mb4_unicode_ci')
      $strError = GetMessage("SC_CONNECTION_COLLATION_WRONG_UTF", array('#VAL#' => $collation_connection));
}
else
{
   if ($bAllIn1251 && $character_set_connection != 'cp1251')
      $strError = GetMessage("SC_CONNECTION_CHARSET_WRONG", array('#VAL#' => 'cp1251', '#VAL1#' => $character_set_connection));
   elseif ($character_set_connection == 'utf8mb4')
      $strError = GetMessage("SC_CONNECTION_CHARSET_WRONG_NOT_UTF", array('#VAL#' => $character_set_connection));
}

Collaborate with us and edit this page