Смена кодировки в Yii2. Настройка MySQL Server
товарищи.
Не могу понять в чем проблема, почему слетела кодировка с данных, которые подтягиваются с MySQL.
- Кодировка БД откуда подтягиваются данные:
- Кодировка таблиц:
Подключение к БД в конфиге Yii2:
'db' => [ 'dsn' => 'mysql:host=localhost;dbname=crm', ... 'charset' => 'utf8', ]Конфигурация кодировок на Sql Server:
mysql> show collation like 'latin1%';SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%'; +-------------------+---------+----+---------+----------+---------+---------------+ | Collation | Charset | Id | Default | Compiled | Sortlen | Pad_attribute | +-------------------+---------+----+---------+----------+---------+---------------+ | latin1_bin | latin1 | 47 | | Yes | 1 | PAD SPACE | | latin1_danish_ci | latin1 | 15 | | Yes | 1 | PAD SPACE | | latin1_general_ci | latin1 | 48 | | Yes | 1 | PAD SPACE | | latin1_general_cs | latin1 | 49 | | Yes | 1 | PAD SPACE | | latin1_german1_ci | latin1 | 5 | | Yes | 1 | PAD SPACE | | latin1_german2_ci | latin1 | 31 | | Yes | 2 | PAD SPACE | | latin1_spanish_ci | latin1 | 94 | | Yes | 1 | PAD SPACE | | latin1_swedish_ci | latin1 | 8 | Yes | Yes | 1 | PAD SPACE | +-------------------+---------+----+---------+----------+---------+---------------+ 8 rows in set (0.00 sec) +--------------------------+--------------------+ | Variable_name | Value | +--------------------------+--------------------+ | character_set_client | cp866 | | character_set_connection | cp866 | | character_set_database | utf8mb4 | | character_set_filesystem | binary | | character_set_results | cp866 | | character_set_server | utf8mb4 | | character_set_system | utf8mb3 | | collation_connection | cp866_general_ci | | collation_database | utf8mb4_0900_ai_ci | | collation_server | utf8mb4_0900_ai_ci | +--------------------------+--------------------+ 10 rows in set, 1 warning (0.00 sec)Операционка Windows 11
Вопрос, почему кодировка слетает?


