При простом запуске mysql и всех вообще скриптах вылезает
mysql: Warning: Charset id '33' csname 'utf8' trying to replace existing csname 'utf8mb3'
mysql: Warning: Charset id '83' csname 'utf8' trying to replace existing csname 'utf8mb3'
Код:
show variables like '%collation%';
+----------------------+--------------------+
| Variable_name | Value |
+----------------------+--------------------+
| collation_connection | utf8mb4_unicode_ci |
| collation_database | utf8mb4_unicode_ci |
| collation_server | utf8mb4_unicode_ci |
+----------------------+--------------------+
3 rows in set (0,001 sec)
MariaDB [(none)]> show variables like '%char%';
+--------------------------+------------------------------+
| Variable_name | Value |
+--------------------------+------------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb3 |
| character_sets_dir | /usr/share/mariadb/charsets/ |
+--------------------------+------------------------------+
8 rows in set (0,001 sec)
Код:
[client]
...
default-character-set=utf8mb4
[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8mb4
[mysqld]
...
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
где у меня еще залипло utf8? прошу помощи... уперся рогом уже :(