История изменений [назад]

Добрый день. Прошу помочь в следующем вопросе. Asterisk пишет в таблицу cdr русский callerID в виде кракозябр. /etc/odbc.ini

Charset=utf8

/etc/my.cnf

init-connect = "SET NAMES utf8"
character-set-server = utf8
collation-server=utf8_general_ci

База и таблица в UTF-8

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 14, FreePBX 14 пишет в таблицу cdr русский callerID в виде кракозябр. /etc/odbc.ini

Charset=utf8

/etc/my.cnf

init-connect = "SET NAMES utf8"
character-set-server = utf8
collation-server=utf8_general_ci

База и таблица в UTF-8

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 14, FreePBX 14 пишет в таблицу cdr русский callerID в виде кракозябр. /etc/odbc.ini

Charset=utf8

/etc/my.cnf

init-connect = "SET NAMES utf8"
character-set-server = utf8
collation-server=utf8_general_ci

База и таблица в UTF-8

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 14, FreePBX 14 пишет в таблицу cdr русский callerID в виде кракозябр. /etc/odbc.ini

Charset=utf8

/etc/my.cnf

init-connect = "SET NAMES utf8"
character-set-server = utf8
collation-server=utf8_general_ci

База и таблица в UTF-8

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               |

Пробовал проделать, как пишут здесь https://voxlink.ru/kb/asterisk-configuration/russian-caller-id-in-freepbx/ - проблема осталась