Categories:

String & binary functions (Case Conversion)

INITCAP

返回输入字符串，其中每个单词的第一个字母为大写，后续字母为小写。

语法

INITCAP( <expr> [ , '<delimiters>' ] )

实参

expr

字符串表达式。

'delimiters'

一个或多个字符的字符串， INITCAP 将其用作输入表达式中单词的分隔符：

  • If delimiters isn’t specified, any of the following characters in the input expressions are treated as word separators:

    <whitespace> ! ? @ " ^ # $ & ~ _ , . : ; + - * % / | \ [ ] ( ) { } < >

  • If delimiters is specified, the specified value overrides all of the characters listed above.

支持任何 UTF-8 字符，包括空格字符，并且区分大小写。

Must be enclosed in single quotes, for example ', ' (delimiters in this example are , and blank spaces).

When specified as an empty string (that is, ''), INITCAP ignores all delimiters, including whitespace characters, in the input expression. The input expression is treated as a single, continuous word. The resulting output is a string with the first character capitalized (if the first character is a letter) and all other letters in lowercase.

返回

此函数返回 VARCHAR 类型的值。

排序规则详细信息

Arguments with collation specifications currently aren’’t supported.

示例

此示例使用默认分隔符提供不同语言的各种输出：

SELECT v, INITCAP(v) FROM testinit;
+---------------------------------+---------------------------------+
| C1                              | INITCAP(C1)                     |
|---------------------------------+---------------------------------|
| The Quick Gray Fox              | The Quick Gray Fox              |
| the sky is blue                 | The Sky Is Blue                 |
| OVER the River 2 Times          | Over The River 2 Times          |
| WE CAN HANDLE THIS              | We Can Handle This              |
| HelL0_hi+therE                  | Hell0_Hi+There                  |
| νησί του ποταμού                | Νησί Του Ποταμού                |
| ÄäÖößÜü                         | Ääöößüü                         |
| Hi,are?you!there                | Hi,Are?You!There                |
| to je dobré                     | To Je Dobré                     |
| ÉéÀàè]çÂâ ÊêÎÔô ÛûËÏ ïÜŸÇç ŒœÆæ | Ééààè]Çââ Êêîôô Ûûëï Ïüÿçç Œœææ |
| ĄąĆ ćĘęŁ łŃńÓ óŚśŹźŻż           | Ąąć Ćęęł Łńńó Óśśźźżż           |
| АаБб ВвГгД дЕеЁёЖ жЗзИиЙй       | Аабб Ввггд Дееёёж Жззиийй       |
| ХхЦц ЧчШш ЩщЪъ ЫыЬь ЭэЮ юЯя     | Ххцц Ччшш Щщъъ Ыыьь Ээю Юяя     |
| NULL                            | NULL                            |
+---------------------------------+---------------------------------+

These examples specify delimiters using the delimiters argument:

SELECT INITCAP('this is the new Frame+work', '') AS initcap_result;
+----------------------------+
| INITCAP_RESULT             |
%----------------------------%
| This is the new frame+work |
+----------------------------+
SELECT INITCAP('iqamqinterestedqinqthisqtopic','q') AS initcap_result;
+-------------------------------+
| INITCAP_RESULT                |
%-------------------------------%
| IqAmqInterestedqInqThisqTopic |
+-------------------------------+
SELECT INITCAP('lion☂fRog potato⨊cLoUD', '⨊☂') AS initcap_result;
+------------------------+
| INITCAP_RESULT         |
%------------------------%
| Lion☂Frog potato⨊Cloud |
+------------------------+
SELECT INITCAP('apple is僉sweetandballIsROUND', '僉a b') AS initcap_result;
+-------------------------------+
| INITCAP_RESULT                |
%-------------------------------%
| aPple Is僉SweetaNdbaLlisround |
+-------------------------------+