5.5.5. mroonga_normalize()#

Added in version 5.11.

5.5.5.1. Summary#

mroonga_normalize() UDF normalizes text by Groonga’s normalizer.

5.5.5.2. Syntax#

mroonga_normalize() has required parameter and optional parameter:

mroonga_normalize(string)
mroonga_normalize(string, normalizer_name)

5.5.5.3. Usage#

Here is the example query which use Groonga’s NormalizerAuto normalizer to be normalized:

SELECT mroonga_normalize("ABCDあぃうぇ㍑");
abcdあぃうぇリットル

Here is the example query which use Groonga’s NormalizerMySQLUnicodeCIExceptKanaCIKanaWithVoicedSoundMark normalizer to be normalized:

SELECT mroonga_normalize("aBｃＤあぃウェ㍑", "NormalizerMySQLUnicodeCIExceptKanaCIKanaWithVoicedSoundMark");
ABCDあぃうぇ㍑

5.5.5.4. Parameters#

5.5.5.4.1. Required parameters#

There is one required parameter, string.

5.5.5.4.1.1. string#

It specifies text which you want to normalize.

5.5.5.4.2. Optional parameters#

There is one optional parameter, normalizer_name.

5.5.5.4.2.1. normalizer_name#

It specifies Groonga’s normalizer name to normalize.

The default value is NormalizerAuto.

5.5.5.5. Return value#

It returns normalized string.