5.5.5. mroonga_normalize()¶
New 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.