> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-locales.md).

# SHOW LOCALES

## Syntax

```bnf
SHOW LOCALES
```

## Description

`SHOW LOCALES` was introduced as part of the [Information Schema plugin extension](/docs/server/reference/system-tables/information-schema/information-schema-tables/plugins-table-information-schema.md).

`SHOW LOCALES` is used to return [locales](/docs/server/reference/data-types/string-data-types/character-sets/internationalization-and-localization/server-locale.md) information as part of the [Locales](/docs/server/reference/data-types/string-data-types/character-sets/internationalization-and-localization/locales-plugin.md) plugin. It requires this plugin to be installed to work.

While the [information\_schema.LOCALES](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-locales-table.md) table has 8 columns, the `SHOW LOCALES` statement will only display 4 of them:

## Example

```sql
SHOW LOCALES;
+-----+-------+-------------------------------------+------------------------+
| Id  | Name  | Description                         | Error_Message_Language |
+-----+-------+-------------------------------------+------------------------+
|   0 | en_US | English - United States             | english                |
|   1 | en_GB | English - United Kingdom            | english                |
|   2 | ja_JP | Japanese - Japan                    | japanese               |
|   3 | sv_SE | Swedish - Sweden                    | swedish                |
...
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}