/etc/odbc.ini
Код: Выделить всё
Charset=utf8
Код: Выделить всё
init-connect = "SET NAMES utf8"
character-set-server = utf8
collation-server=utf8_general_ci
Код: Выделить всё
MariaDB [asteriskcdrdb]> SELECT default_character_set_name FROM information_schema.SCHEMATA WHERE schema_name = "asteriskcdrdb";
+----------------------------+
| default_character_set_name |
+----------------------------+
| utf8
SELECT CCSA.character_set_name FROM information_schema.`TABLES` T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema = "asteriskcdrdb" AND T.table_name = "cdr";
+--------------------+
| character_set_name |
+--------------------+
| utf8 |
В консоли asterisk отображается русский CallerID, но в базе нет.