The Ultimate Guide to High Availability with MariaDB

Setting the Language for Error Messages

You are viewing an old version of this article. View the current version here.

Contents

  1. Setting the lc_messages System Variable
  2. Setting the --language Option
  3. Character Set

MariaDB server error messages are by default in English. You can change this to a number of other languages. As of MariaDB 10.0, error messages are available in the following languages

  • Czech
  • Danish
  • Dutch
  • English
  • Estonian
  • French
  • German
  • Greek
  • Hungarian
  • Italian
  • Japanese
  • Korean
  • Norwegian
  • Norwegian-ny (Nynorsk)
  • Polish
  • Portuguese
  • Romanian
  • Russian
  • Serbian
  • Slovak
  • Spanish
  • Swedish
  • Ukrainian

The actual error message file is errmsg.sys, and there is one for each available language, stored in a different directory.

Setting the lc_messages System Variable

The lc_messages and lc_messages_dir system variables can be used to set the server locale used for error messages.

The lc_messages system variable is specified as the language name. See locales for a list of locales and their related languages.

Any valid locale may be specified. If an [[error-log/#error-messages-file|error message file] for the associated language is not found, then the default locale (English) will be used instead.

The lc_messages_dir system variable is specified as the path to the directory storing the server's error message files.

These system variables can be specified as command-line arguments to mysqld or they can be specified in a relevant server option group in an option file. For example:

[mariadb]
...
lc_messages=fr_CA
lc_messages_dir=/usr/share/mysql

The lc_messages system variable can also be changed dynamically with SET GLOBAL. For example:

SET GLOBAL lc_messages='fr_CA';

The lc_messages_dir system variable can not be changed dynamically.

With the above configuration, error messages would be in French.:

...
SELECT blah;
ERROR 1054 (42S22): Champ 'blah' inconnu dans field list

Setting the --language Option

The --language option can also be used to set the server's language for error messages, but it is deprecated. It is recommended to set the lc_messages system variable instead.

The --language option option can be specified as a language name. See locales for a list of locales and their related languages. For example: 

mysqld --language=estonian

The --language option option can be specified as the path to the directory storing the language's error message file. For example:

mysqld --language=/my/maria-10.0.13/sql/share/danish/

Character Set

The character set that the error messages are returned in is determined by the character_set_results variable, which defaults to UTF8.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.