Froxlor admin panel + Mysql

[fufaev]

Hello. Help me please. Cyrillic characters are not displayed correctly in admin panel.

How to change the charset Froxlor panel of administration for a connection with Mysql database? (latin_swedish_ci --> utf8_general_ci)

 

[d00p]

Froxlor already *is* utf-8...check your mysql-server-settings if you maybe changed the default connection-charset or something similar

[fufaev]

Problem appeared after update 9.31.1.

Database charset - utf8.

Found that the admin panel writes (takes) in the database in latin1_swedish_ci.  Customer sites work fine (utf8).

Decided to change the charset for the panel, but I can not find where changes.

 

OS: Debian 6

Panel: 0.9.31-1+squeeze1

Mysql: 5.1.72-2

[d00p]

Are you sure froxlor writes values in latin1_swedish_ci? Besides, we would never use latin1_swedish_ci...why would we use SWEDISH? Please check your mysql-server configuration. Froxlor uses 100% utf-8

[fufaev]

 

Please check your mysql-server configuration. Froxlor uses 100% utf-8

Mysql settings

 

mysql> \s

--------------

mysql  Ver 14.14 Distrib 5.1.72, for debian-linux-gnu (x86_64) using readline 6.1

 

Connection id:        5776

Current database:    froxlor

Current user:        root@localhost

SSL:            Not in use

Current pager:        stdout

Using outfile:        ''

Using delimiter:    ;

Server version:        5.1.72-2 (Debian)

Protocol version:    10

Connection:        Localhost via UNIX socket

Server characterset:    utf8

Db     characterset:    utf8

Client characterset:    utf8

Conn.  characterset:    utf8

UNIX socket:        /var/run/mysqld/mysqld.sock

Uptime:            1 day 6 min 23 sec

 

Threads: 10  Questions: 158190  Slow queries: 0  Opens: 5998  Flush tables: 1  Open tables: 64  Queries per second avg: 1.822

--------------

 

mysql> SHOW VARIABLES;

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/                                                                |

| collation_connection                    | utf8_general_ci                                                                           |

| collation_database                      | utf8_general_ci                                                                           |

| collation_server                        | utf8_unicode_ci