How to set mariadb character code for using cp 932 at client side ?
Issue
- How to set mariadb character code for using cp 932 at client side ?
Environment
- Red Hat Enterprise Linux 7.x
Server version: 5.5.47-MariaDB-log MariaDB Server
User wants to use cp932 character code therefore he sets my.cnf like below.
[mysqld]
character-set-server = cp932
Restart mariadb server.
Check character code status with below sql.
MariaDB [(none)]> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | cp932 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | cp932 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
But he found below setting was not changed then wants to know how to change below value.
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_results | utf8 |
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.