Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.2.14
-
None
-
Debian 9.4 + 10.2.14-MariaDB-10.2.14+maria~stretch-log
Description
in my.cnf
character_set_client = 'latin1' |
in MariaDB
MariaDB [(none)]> show global variables like 'character_set_client'; |
+----------------------+-------+
|
| Variable_name | Value |
|
+----------------------+-------+
|
| character_set_client | utf8 |
|
+----------------------+-------+
|
1 row in set (0.00 sec) |
Why ? (i want put everything in utf-8 except character_set_client but look it's not possible anymore with my.cnf
the workaround :
MariaDB [(none)]> set global character_set_client = 'latin1'; |
Query OK, 0 rows affected (0.00 sec) |
|
MariaDB [(none)]> show global variables like 'character_set_client'; |
+----------------------+--------+
|
| Variable_name | Value |
|
+----------------------+--------+
|
| character_set_client | latin1 |
|
+----------------------+--------+
|
1 row in set (0.00 sec) |
|
full listing : (maybe it's bad, but my goal is only to upgrade the version of MariaDB), and put exactly the same configuration like it's was before.
MariaDB [(none)]> show global variables like 'character_%'; |
+--------------------------+----------------------------+
|
| Variable_name | Value |
|
+--------------------------+----------------------------+
|
| character_set_client | latin1 |
|
| 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/ |
|
+--------------------------+----------------------------+
|
8 rows in set (0.00 sec) |