MySQL Forums
Forum List  »  Newbie

system_time_zone
Posted by: Benoit St-Jean
Date: May 13, 2023 02:05AM

My server seems to have garbage stored in the system_time_zone variable.

It's currently set at "Est (Heure d'été)' and causes all kinds of problems.

I'm on Windows 10 and using MySql 5.7.11

Where is this variable set or retrieved. It's not showing anywhere in the my.ini configuration file nor in any windows system variable!

Other timezone related variables:

+--------------------+
| @@system_time_zone |
+--------------------+
| Est (heure d’été) |
+--------------------+
1 row in set (0.00 sec)

mysql> show variables like '%zone';
+------------------+--------------+
| Variable_name | Value |
+------------------+--------------+
| system_time_zone | Est (heure d |
| time_zone | -05:00 |
+------------------+--------------+
2 rows in set, 1 warning (0.00 sec)

mysql> show warnings;
+---------+------+---------------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+---------------------------------------------------------------------------------+
| Warning | 1366 | Incorrect string value: '\x92\xE9t\xE9)' for column 'VARIABLE_VALUE' at row 478 |
+---------+------+---------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Options: ReplyQuote


Subject
Written By
Posted
system_time_zone
May 13, 2023 02:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.