Доброго времени суток, господа.
Имеется вопрос. При подтверждении (Acknowledge) проблемы комментарием, содержащим кириллицу - после сохранения вместо русских символов в сообщении-подтверждении отображаются знаки вопроса. Везде где мог выставил UTF8. Проблема не решилась. Подскажите, пожалуйста, куда ещё копнуть.
CentOS 6
Zabbix 2.0.3
MySql 5.1.66
PHP 5.3.3
Apache/2.2.15
/etc/my.cnf:
[mysqld]
character_set_server=utf8
collation_server=utf8_unicode_ci
init-connect="SET NAMES utf8"
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
default-storage-engine = InnoDB
innodb_file_per_table
[client]
default-character-set=utf8
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysql]
default-character-set=utf8
/etc/php.ini:
...
mbstring.internal_encoding = UTF-8
...
mysql> status
--------------
mysql Ver 14.14 Distrib 5.1.66, for redhat-linux-gnu (x86_64) using readline 5.1
Connection id: 1627
Current database: zabbix
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.66 Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 15 min 27 sec
Threads: 24 Questions: 52721 Slow queries: 0 Opens: 255 Flush tables: 1 Open tables: 64 Queries per second avg: 56.872
--------------
mysql> show variables like "%collat%";
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_unicode_ci |
| collation_server | utf8_unicode_ci |
+----------------------+-----------------+
mysql> show variables like "char%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
Имеется вопрос. При подтверждении (Acknowledge) проблемы комментарием, содержащим кириллицу - после сохранения вместо русских символов в сообщении-подтверждении отображаются знаки вопроса. Везде где мог выставил UTF8. Проблема не решилась. Подскажите, пожалуйста, куда ещё копнуть.
CentOS 6
Zabbix 2.0.3
MySql 5.1.66
PHP 5.3.3
Apache/2.2.15
/etc/my.cnf:
[mysqld]
character_set_server=utf8
collation_server=utf8_unicode_ci
init-connect="SET NAMES utf8"
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
default-storage-engine = InnoDB
innodb_file_per_table
[client]
default-character-set=utf8
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysql]
default-character-set=utf8
/etc/php.ini:
...
mbstring.internal_encoding = UTF-8
...
mysql> status
--------------
mysql Ver 14.14 Distrib 5.1.66, for redhat-linux-gnu (x86_64) using readline 5.1
Connection id: 1627
Current database: zabbix
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.66 Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 15 min 27 sec
Threads: 24 Questions: 52721 Slow queries: 0 Opens: 255 Flush tables: 1 Open tables: 64 Queries per second avg: 56.872
--------------
mysql> show variables like "%collat%";
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_unicode_ci |
| collation_server | utf8_unicode_ci |
+----------------------+-----------------+
mysql> show variables like "char%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
Comment