MySQL Bugs: #60395: show global variables requrns weired warnings on JP MS Windows.

Bug #60395	show global variables requrns weired warnings on JP MS Windows.
Submitted:	8 Mar 2011 17:40
Reporter:	Meiji KIMURA	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Windows	Severity:	S3 (Non-critical)
Version:	5.1.56, 5.5.9	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
On JP MS Windows, 'SHOW GLOBAL VARIABLES;' returns weired warnings.
I looked into this, I found that it is caused by 'system_time_zone'.

mysql> show global variables like 'system_time_zone';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| system_time_zone |       |
+------------------+-------+
1 row in set, 1 warning (0.00 sec)

mysql> show warnings\G
*************************** 1. row ***************************
  Level: Warning
   Code: 1366
Message: Incorrect string value: '\x93\x8C\x8B\x9E (...' for column 'VARIABLE_VALUE' at row 1
1 row in set (0.00 sec)

938c8b9e means '東京' in Shift Jis code(in MySQL sjis or cp932), 
so it is bad manner of JP Microsoft Windows.
(I supposed that MS windows returns '東京標準時' in Shift Jis code. (Tokyo Standard time).

How to repeat:
See 'Description:'

[Workaround]

Ignore this warnings.

[Suggest to Fix]

I don't know, I think some MS windows returns 'system_time_zone' as local language, but it is difficult to handle it properly....

I confirm the bug on Windos 7. My Windows is Russian and so the system timezone is in Russian (Moscow time). It is returned by Windows and I can't change it (nor should I). The variable time_zone=SYSTEM hence MySql reads system_time_zone. Usually when I have to deal with Cyrillic strings I set variables character_set* to the right value (Set Names='cp1251') and that does the trick. But in this case even though I set all the variables except character_set_system to cp1251 the warning is still there. I have no control over that because MySql reads the value from the system, not from a table.

The situation is same for MySQL 5.6/5.7/8.0 on Windows 10.

mysql> show global variables like 'system_time_zone';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| system_time_zone |       |
+------------------+-------+
1 row in set, 1 warning (0.01 sec)

mysql> show warnings;
+---------+------+--------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                              |
+---------+------+--------------------------------------------------------------------------------------+
| Warning | 1366 | Incorrect string value: '\x93\x8C\x8B\x9E (...' for column 'VARIABLE_VALUE' at row 1 |
+---------+------+--------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select @@version;
+-------------------+
| @@version         |
+-------------------+
| 8.0.22-commercial |
+-------------------+
1 row in set (0.00 sec)