MySQL 8 Administrator???s Guide

Locale support

MySQL 8 uses lc_time_names system variables to control languages which will impact what day, month name, and abbreviations will be displayed. The DATE_FORMAT(), DAYNAME(), and MONTHNAME() function outputs depend on the lc_time_names variable's value. The first question that comes to mind is, where are these locales defined and how do we get them? Not to worry, refer to http://www.iana.org/assignments/language-subtag-registry. All locales are defined with language and region abbreviations by Internet Assigned Numbers Authority (IANA). By default, MySQL 8 sets en_US as the locale in the system variable. There is provision for the user to set the value on server startup or to set GLOBAL if they have SYSTEM_VARIABLES_ADMIN or ...