This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 9f77edbaf20 [doc]add utf8 cas for ucase / lcase (#2964)
9f77edbaf20 is described below
commit 9f77edbaf200fbf61a0013df6339426a9dfca0db
Author: Mryange <[email protected]>
AuthorDate: Mon Oct 13 13:29:39 2025 +0800
[doc]add utf8 cas for ucase / lcase (#2964)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../scalar-functions/string-functions/lcase.md | 15 ++++++++++-
.../scalar-functions/string-functions/ucase.md | 29 +++++++++++++--------
.../scalar-functions/string-functions/lcase.md | 20 +++++++++++----
.../scalar-functions/string-functions/ucase.md | 30 ++++++++++++++--------
.../scalar-functions/string-functions/lcase.md | 15 ++++++++++-
.../scalar-functions/string-functions/ucase.md | 30 ++++++++++++++--------
.../scalar-functions/string-functions/lcase.md | 15 ++++++++++-
.../scalar-functions/string-functions/ucase.md | 30 ++++++++++++++--------
.../scalar-functions/string-functions/lcase.md | 15 ++++++++++-
.../scalar-functions/string-functions/ucase.md | 29 +++++++++++++--------
.../scalar-functions/string-functions/lcase.md | 15 ++++++++++-
.../scalar-functions/string-functions/ucase.md | 29 +++++++++++++--------
12 files changed, 199 insertions(+), 73 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
index 4411bf9cb74..522d7fc12ac 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
@@ -1,6 +1,6 @@
---
{
- "title": "LCASE",
+ "title": "LCASE/LOWER",
"language": "en"
}
---
@@ -17,6 +17,7 @@ Convert all strings in the parameter to lowercase.
```sql
LCASE ( <str> )
+LOWER ( <str> )
```
## Parameters
@@ -42,3 +43,15 @@ SELECT LCASE("AbC123"),LOWER("AbC123")
| abc123 | abc123 |
+-----------------+-----------------+
```
+
+```sql
+SELECT LOWER("ҚAZAҚ123"),LCASE("ҒАРЫШ");
+```
+
+```text
++---------------------+---------------------+
+| LOWER("ҚAZAҚ123") | LCASE("ҒАРЫШ") |
++---------------------+---------------------+
+| қazaқ123 | ғарыш |
++---------------------+---------------------+
+```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
index 0835bcb61c8..b91148bc0c8 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
@@ -1,6 +1,6 @@
---
{
- "title": "UCASE",
+ "title": "UCASE/UPPER",
"language": "en"
}
---
@@ -8,14 +8,12 @@
## Description
Used to convert a string to uppercase letters
-## Alias
-
-- UPPER
## Syntax
```sql
UCASE( <str> )
+UPPER( <str> )
```
## Required Parameters
@@ -30,12 +28,23 @@ The value after converting the uppercase
## Example
```sql
-SELECT ucase("aBc123");
+SELECT UCASE("aBc123"),UPPER("aBc123");
+```
+```sql
++-----------------+-----------------+
+| UCASE("aBc123") | UPPER("aBc123") |
++-----------------+-----------------+
+| ABC123 | ABC123 |
++-----------------+-----------------+
+```
+
+```sql
+SELECT UCASE("Кириллица"),UPPER("Бәйтерек");
```
```sql
-+-----------------+
-| ucase('aBc123') |
-+-----------------+
-| ABC123 |
-+-----------------+
++-----------------------------+---------------------------+
+| UCASE("Кириллица") | UPPER("Бәйтерек") |
++-----------------------------+---------------------------+
+| КИРИЛЛИЦА | БӘЙТЕРЕК |
++-----------------------------+---------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
index 39a92ab19fe..3a87052d69e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
@@ -1,6 +1,6 @@
---
{
- "title": "LCASE",
+ "title": "LCASE/LOWER",
"language": "zh-CN"
}
---
@@ -9,14 +9,11 @@
将参数中所有的字符串都转换成小写。
-## 别名
-
-- LOWER
-
## 语法
```sql
LCASE ( <str> )
+LOWER ( <str> )
```
## 参数
@@ -42,3 +39,16 @@ SELECT LOWER("AbC123"),LCASE("AbC123")
| abc123 | abc123 |
+-----------------+-----------------+
```
+
+
+```sql
+SELECT LOWER("ҚAZAҚ123"),LCASE("ҒАРЫШ");
+```
+
+```text
++---------------------+---------------------+
+| LOWER("ҚAZAҚ123") | LCASE("ҒАРЫШ") |
++---------------------+---------------------+
+| қazaқ123 | ғарыш |
++---------------------+---------------------+
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
index ef877c5a2a8..9c579556b56 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
@@ -1,6 +1,6 @@
---
{
- "title": "UCASE",
+ "title": "UCASE/UPPER",
"language": "zh-CN"
}
---
@@ -9,14 +9,11 @@
用于将字符串转换为大写字母
-## 别名
-
-- UPPER
-
## 语法
```sql
UCASE( <str> )
+UPPER( <str> )
```
## 必选参数
@@ -31,12 +28,23 @@ UCASE( <str> )
### 示例
```sql
-SELECT ucase("aBc123");
+SELECT UCASE("aBc123"),UPPER("aBc123");
+```
+```sql
++-----------------+-----------------+
+| UCASE("aBc123") | UPPER("aBc123") |
++-----------------+-----------------+
+| ABC123 | ABC123 |
++-----------------+-----------------+
```
+
```sql
-+-----------------+
-| ucase('aBc123') |
-+-----------------+
-| ABC123 |
-+-----------------+
+SELECT UCASE("Кириллица"),UPPER("Бәйтерек");
```
+```sql
++-----------------------------+---------------------------+
+| UCASE("Кириллица") | UPPER("Бәйтерек") |
++-----------------------------+---------------------------+
+| КИРИЛЛИЦА | БӘЙТЕРЕК |
++-----------------------------+---------------------------+
+```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
index 39a92ab19fe..5f8dd5fdd2a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
@@ -1,6 +1,6 @@
---
{
- "title": "LCASE",
+ "title": "LCASE/LOWER",
"language": "zh-CN"
}
---
@@ -17,6 +17,7 @@
```sql
LCASE ( <str> )
+LOWER ( <str> )
```
## 参数
@@ -42,3 +43,15 @@ SELECT LOWER("AbC123"),LCASE("AbC123")
| abc123 | abc123 |
+-----------------+-----------------+
```
+
+```sql
+SELECT LOWER("ҚAZAҚ123"),LCASE("ҒАРЫШ");
+```
+
+```text
++---------------------+---------------------+
+| LOWER("ҚAZAҚ123") | LCASE("ҒАРЫШ") |
++---------------------+---------------------+
+| қazaқ123 | ғарыш |
++---------------------+---------------------+
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
index ef877c5a2a8..59fa3ac6c87 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
@@ -1,6 +1,6 @@
---
{
- "title": "UCASE",
+ "title": "UCASE/UPPER",
"language": "zh-CN"
}
---
@@ -9,14 +9,11 @@
用于将字符串转换为大写字母
-## 别名
-
-- UPPER
-
## 语法
```sql
UCASE( <str> )
+UPPER( <str> )
```
## 必选参数
@@ -31,12 +28,23 @@ UCASE( <str> )
### 示例
```sql
-SELECT ucase("aBc123");
+SELECT UCASE("aBc123"),UPPER("aBc123");
+```
+```sql
++-----------------+-----------------+
+| UCASE("aBc123") | UPPER("aBc123") |
++-----------------+-----------------+
+| ABC123 | ABC123 |
++-----------------+-----------------+
+```
+
+```sql
+SELECT UCASE("Кириллица"),UPPER("Бәйтерек");
```
```sql
-+-----------------+
-| ucase('aBc123') |
-+-----------------+
-| ABC123 |
-+-----------------+
++-----------------------------+---------------------------+
+| UCASE("Кириллица") | UPPER("Бәйтерек") |
++-----------------------------+---------------------------+
+| КИРИЛЛИЦА | БӘЙТЕРЕК |
++-----------------------------+---------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
index 39a92ab19fe..5f8dd5fdd2a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
@@ -1,6 +1,6 @@
---
{
- "title": "LCASE",
+ "title": "LCASE/LOWER",
"language": "zh-CN"
}
---
@@ -17,6 +17,7 @@
```sql
LCASE ( <str> )
+LOWER ( <str> )
```
## 参数
@@ -42,3 +43,15 @@ SELECT LOWER("AbC123"),LCASE("AbC123")
| abc123 | abc123 |
+-----------------+-----------------+
```
+
+```sql
+SELECT LOWER("ҚAZAҚ123"),LCASE("ҒАРЫШ");
+```
+
+```text
++---------------------+---------------------+
+| LOWER("ҚAZAҚ123") | LCASE("ҒАРЫШ") |
++---------------------+---------------------+
+| қazaқ123 | ғарыш |
++---------------------+---------------------+
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
index ef877c5a2a8..59fa3ac6c87 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
@@ -1,6 +1,6 @@
---
{
- "title": "UCASE",
+ "title": "UCASE/UPPER",
"language": "zh-CN"
}
---
@@ -9,14 +9,11 @@
用于将字符串转换为大写字母
-## 别名
-
-- UPPER
-
## 语法
```sql
UCASE( <str> )
+UPPER( <str> )
```
## 必选参数
@@ -31,12 +28,23 @@ UCASE( <str> )
### 示例
```sql
-SELECT ucase("aBc123");
+SELECT UCASE("aBc123"),UPPER("aBc123");
+```
+```sql
++-----------------+-----------------+
+| UCASE("aBc123") | UPPER("aBc123") |
++-----------------+-----------------+
+| ABC123 | ABC123 |
++-----------------+-----------------+
+```
+
+```sql
+SELECT UCASE("Кириллица"),UPPER("Бәйтерек");
```
```sql
-+-----------------+
-| ucase('aBc123') |
-+-----------------+
-| ABC123 |
-+-----------------+
++-----------------------------+---------------------------+
+| UCASE("Кириллица") | UPPER("Бәйтерек") |
++-----------------------------+---------------------------+
+| КИРИЛЛИЦА | БӘЙТЕРЕК |
++-----------------------------+---------------------------+
```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
index 4411bf9cb74..522d7fc12ac 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
@@ -1,6 +1,6 @@
---
{
- "title": "LCASE",
+ "title": "LCASE/LOWER",
"language": "en"
}
---
@@ -17,6 +17,7 @@ Convert all strings in the parameter to lowercase.
```sql
LCASE ( <str> )
+LOWER ( <str> )
```
## Parameters
@@ -42,3 +43,15 @@ SELECT LCASE("AbC123"),LOWER("AbC123")
| abc123 | abc123 |
+-----------------+-----------------+
```
+
+```sql
+SELECT LOWER("ҚAZAҚ123"),LCASE("ҒАРЫШ");
+```
+
+```text
++---------------------+---------------------+
+| LOWER("ҚAZAҚ123") | LCASE("ҒАРЫШ") |
++---------------------+---------------------+
+| қazaқ123 | ғарыш |
++---------------------+---------------------+
+```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
index 0835bcb61c8..b91148bc0c8 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
@@ -1,6 +1,6 @@
---
{
- "title": "UCASE",
+ "title": "UCASE/UPPER",
"language": "en"
}
---
@@ -8,14 +8,12 @@
## Description
Used to convert a string to uppercase letters
-## Alias
-
-- UPPER
## Syntax
```sql
UCASE( <str> )
+UPPER( <str> )
```
## Required Parameters
@@ -30,12 +28,23 @@ The value after converting the uppercase
## Example
```sql
-SELECT ucase("aBc123");
+SELECT UCASE("aBc123"),UPPER("aBc123");
+```
+```sql
++-----------------+-----------------+
+| UCASE("aBc123") | UPPER("aBc123") |
++-----------------+-----------------+
+| ABC123 | ABC123 |
++-----------------+-----------------+
+```
+
+```sql
+SELECT UCASE("Кириллица"),UPPER("Бәйтерек");
```
```sql
-+-----------------+
-| ucase('aBc123') |
-+-----------------+
-| ABC123 |
-+-----------------+
++-----------------------------+---------------------------+
+| UCASE("Кириллица") | UPPER("Бәйтерек") |
++-----------------------------+---------------------------+
+| КИРИЛЛИЦА | БӘЙТЕРЕК |
++-----------------------------+---------------------------+
```
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
index 4411bf9cb74..522d7fc12ac 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/lcase.md
@@ -1,6 +1,6 @@
---
{
- "title": "LCASE",
+ "title": "LCASE/LOWER",
"language": "en"
}
---
@@ -17,6 +17,7 @@ Convert all strings in the parameter to lowercase.
```sql
LCASE ( <str> )
+LOWER ( <str> )
```
## Parameters
@@ -42,3 +43,15 @@ SELECT LCASE("AbC123"),LOWER("AbC123")
| abc123 | abc123 |
+-----------------+-----------------+
```
+
+```sql
+SELECT LOWER("ҚAZAҚ123"),LCASE("ҒАРЫШ");
+```
+
+```text
++---------------------+---------------------+
+| LOWER("ҚAZAҚ123") | LCASE("ҒАРЫШ") |
++---------------------+---------------------+
+| қazaқ123 | ғарыш |
++---------------------+---------------------+
+```
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
index c701b446763..0d319c58adf 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/ucase.md
@@ -1,6 +1,6 @@
---
{
- "title": "UCASE",
+ "title": "UCASE/UPPER",
"language": "en"
}
---
@@ -8,14 +8,12 @@
## Description
Used to convert a string to uppercase letters
-## Alias
-
-- UPPER
## Syntax
```sql
UCASE( <str> )
+UPPER( <str> )
```
## Required Parameters
@@ -30,12 +28,23 @@ The value after converting the uppercase
## Example
```sql
-SELECT ucase("aBc123");
+SELECT UCASE("aBc123"),UPPER("aBc123");
+```
+```sql
++-----------------+-----------------+
+| UCASE("aBc123") | UPPER("aBc123") |
++-----------------+-----------------+
+| ABC123 | ABC123 |
++-----------------+-----------------+
+```
+
+```sql
+SELECT UCASE("Кириллица"),UPPER("Бәйтерек");
```
```sql
-+-----------------+
-| ucase('aBc123') |
-+-----------------+
-| ABC123 |
-+-----------------+
++-----------------------------+---------------------------+
+| UCASE("Кириллица") | UPPER("Бәйтерек") |
++-----------------------------+---------------------------+
+| КИРИЛЛИЦА | БӘЙТЕРЕК |
++-----------------------------+---------------------------+
```
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
