> 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/server-usage/storage-engines/mroonga/mroonga-user-defined-functions/mroonga_normalize.md).

# mroonga\_normalize

## Syntax

```
mroonga_normalize(string[, normalizer_name])
```

## Description

`mroonga_normalize` is a [user-defined function](/docs/server/server-usage/user-defined-functions.md) (UDF) included with the [Mroonga storage engine](/docs/server/server-usage/storage-engines/mroonga.md). It uses Groonga's normalizer to normalize text. See [Creating Mroonga User-Defined Functions](/docs/server/server-usage/storage-engines/mroonga/mroonga-user-defined-functions/creating-mroonga-user-defined-functions.md) for details on creating this UDF if required.

Given a string, returns the normalized text.

See the [Groonga Normalizer Reference](https://groonga.org/docs/reference/normalizers.html) for details on the Groonga normalizers. The default if no normalizer is provided is `NormalizerAuto`.

## Examples

```sql
SELECT mroonga_normalize("ABぃ㍑");
+-------------------------------+
| mroonga_normalize("ABぃ㍑")   |
+-------------------------------+
| abぃリットル                  |
+-------------------------------+
```

## See Also

* [Creating Mroonga User-Defined Functions](/docs/server/server-usage/storage-engines/mroonga/mroonga-user-defined-functions/creating-mroonga-user-defined-functions.md)

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

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