MariaDB supports a large list of locales that are used by functions such as DAYNAME()
, MONTHNAME()
and DATE_FORMAT()
.
While these locales are available to MariaDB, by default they’re not loaded into any of the system tables, so you can’t run a query to retrieve them.
However, MariaDB provides a plugin that does load these into a table. Once the plugin has been installed, you can query that table to return the locales available in MariaDB.
Continue reading