This is an automated email from the ASF dual-hosted git repository.
kassiez 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 cc975e031d1 [opt](show) update show collation sql reference manual
(#1410)
cc975e031d1 is described below
commit cc975e031d154bfee70678c775846969856a18f3
Author: morrySnow <zhangwen...@selectdb.com>
AuthorDate: Thu Nov 28 17:10:12 2024 +0800
[opt](show) update show collation sql reference manual (#1410)
# Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [x] 2.0
# Languages
- [x] Chinese
- [x] English
---
.../Show-Statements/SHOW-COLLATION.md | 33 +++++++++++---------
.../Show-Statements/SHOW-COLLATION.md | 35 ++++++++++++----------
.../Show-Statements/SHOW-COLLATION.md | 27 ++++++++++-------
.../Show-Statements/SHOW-COLLATION.md | 35 ++++++++++++----------
.../Show-Statements/SHOW-COLLATION.md | 35 ++++++++++++----------
.../Show-Statements/SHOW-COLLATION.md | 25 +++++++++-------
.../Show-Statements/SHOW-COLLATION.md | 33 +++++++++++---------
.../Show-Statements/SHOW-COLLATION.md | 33 +++++++++++---------
8 files changed, 148 insertions(+), 108 deletions(-)
diff --git a/docs/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
b/docs/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
index 264d0c58532..51eb5e29d47 100644
--- a/docs/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
+++ b/docs/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
@@ -24,11 +24,17 @@ specific language governing permissions and limitations
under the License.
-->
-## SHOW-COLLATION
+## Description
-### Description
+In Doris, the `SHOW COLLATION` command is used to display the character set
collations available in the database. A collation is a set of rules that
determine how data is sorted and compared. These rules affect the storage and
retrieval of character data. Doris currently mainly supports the proofreading
method utf8mb4_0900_bin.
-In Doris, the `SHOW COLLATION` command is used to display the character set
collations available in the database. A collation is a set of rules that
determine how data is sorted and compared. These rules affect the storage and
retrieval of character data. Doris currently mainly supports the proofreading
method utf8_general_ci.
+## Syntax
+
+```
+SHOW COLLATION
+```
+
+## Result Fields
The `SHOW COLLATION` command returns the following fields:
@@ -42,18 +48,17 @@ The `SHOW COLLATION` command returns the following fields:
### Example
```sql
-mysql> show collation;
-+-----------------+---------+------+---------+----------+---------+
-| Collation | Charset | Id | Default | Compiled | Sortlen |
-+-----------------+---------+------+---------+----------+---------+
-| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
-+-----------------+---------+------+---------+----------+---------+
+show collation;
```
-### Keywords
-
- SHOW, COLLATION
+```
++------------------+---------+------+---------+----------+---------+
+| Collation | Charset | Id | Default | Compiled | Sortlen |
++------------------+---------+------+---------+----------+---------+
+| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
++------------------+---------+------+---------+----------+---------+
+```
-### Best Practice
+### Notice
-Use the `SHOW COLLATION` command to give you an idea of the collations
available in the database and their properties. This information can help
ensure that your character data is sorted and compared as expected. If you have
problems comparing or sorting characters, it can be helpful to check your
collation settings to make sure they are what you expect.
+In Doris, although it is compatible with MySQL's commands for setting the
collation, the setting actually does not take effect. When executed, Doris will
always use utf8mb4_0900_bin as the comparison rule.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
index 500ce75c2f0..cad0aa2eb92 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
@@ -24,11 +24,17 @@ specific language governing permissions and limitations
under the License.
-->
-## SHOW-COLLATION
+## 描述
-### Description
+在 Doris 中，`SHOW COLLATION`
命令用于显示数据库中可用的字符集校对。校对是一组决定数据如何排序和比较的规则。这些规则会影响字符数据的存储和检索。Doris 目前主要支持
utf8mb4_0900_bin 这一种校对方式。
-在 Doris 中，`SHOW COLLATION`
命令用于显示数据库中可用的字符集校对。校对是一组决定数据如何排序和比较的规则。这些规则会影响字符数据的存储和检索。Doris 目前主要支持
utf8_general_ci 这一种校对方式。
+## 语法
+
+```
+SHOW COLLATION
+```
+
+## 返回结果
`SHOW COLLATION` 命令返回以下字段：
@@ -39,21 +45,20 @@ under the License.
* Compiled：是否已编译
* Sortlen：排序长度
-### Example
+## 示例
```sql
-mysql> show collation;
-+-----------------+---------+------+---------+----------+---------+
-| Collation | Charset | Id | Default | Compiled | Sortlen |
-+-----------------+---------+------+---------+----------+---------+
-| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
-+-----------------+---------+------+---------+----------+---------+
+how collation;
```
-### Keywords
-
- SHOW, COLLATION
+```
++------------------+---------+------+---------+----------+---------+
+| Collation | Charset | Id | Default | Compiled | Sortlen |
++------------------+---------+------+---------+----------+---------+
+| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
++------------------+---------+------+---------+----------+---------+
+```
-### Best Practice
+## 注意事项
-使用 `SHOW COLLATION`
命令可以让你了解数据库中可用的校对规则及其特性。这些信息可以帮助确保你的字符数据按照预期的方式进行排序和比较。如果遇到字符比较或排序的问题，检查校对设置，确保它们符合你的预期，会是个很有帮助的操作。
+在 Doris 中，虽然兼容 MySQL 的设置 collation 的命令。但是实际并不会生效。执行时，永远会使用 utf8mb4_0900_bin
作为比较规则。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Show-Statements/SHOW-COLLATION.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Show-Statements/SHOW-COLLATION.md
index 9709136f308..94e3d3e0143 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Show-Statements/SHOW-COLLATION.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Show-Statements/SHOW-COLLATION.md
@@ -24,11 +24,17 @@ specific language governing permissions and limitations
under the License.
-->
-## SHOW-COLLATION
+## 描述
-### Description
+在 Doris 中，`SHOW COLLATION`
命令用于显示数据库中可用的字符集校对。校对是一组决定数据如何排序和比较的规则。这些规则会影响字符数据的存储和检索。此命令所返回的内容仅用于兼容 MySQL
的行为。不代表 Doris 真是支持的字符集校对列表。Doris 目前主要支持 utf8mb4_0900_bin 这一种校对方式。
-在 Doris 中，`SHOW COLLATION`
命令用于显示数据库中可用的字符集校对。校对是一组决定数据如何排序和比较的规则。这些规则会影响字符数据的存储和检索。Doris 目前主要支持
utf8_general_ci 这一种校对方式。
+## 语法
+
+```
+SHOW COLLATION
+```
+
+## 返回结果
`SHOW COLLATION` 命令返回以下字段：
@@ -39,10 +45,13 @@ under the License.
* Compiled：是否已编译
* Sortlen：排序长度
-### Example
+## 示例
```sql
-mysql> show collation;
+how collation;
+```
+
+```
+-----------------+---------+------+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+-----------------+---------+------+---------+----------+---------+
@@ -50,10 +59,6 @@ mysql> show collation;
+-----------------+---------+------+---------+----------+---------+
```
-### Keywords
-
- SHOW, COLLATION
-
-### Best Practice
+## 注意事项
-使用 `SHOW COLLATION`
命令可以让你了解数据库中可用的校对规则及其特性。这些信息可以帮助确保你的字符数据按照预期的方式进行排序和比较。如果遇到字符比较或排序的问题，检查校对设置，确保它们符合你的预期，会是个很有帮助的操作。
+在 Doris 中，虽然兼容 MySQL 的设置 collation 的命令。但是实际并不会生效。执行时，永远会使用 utf8mb4_0900_bin
作为比较规则。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
index 500ce75c2f0..cad0aa2eb92 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
@@ -24,11 +24,17 @@ specific language governing permissions and limitations
under the License.
-->
-## SHOW-COLLATION
+## 描述
-### Description
+在 Doris 中，`SHOW COLLATION`
命令用于显示数据库中可用的字符集校对。校对是一组决定数据如何排序和比较的规则。这些规则会影响字符数据的存储和检索。Doris 目前主要支持
utf8mb4_0900_bin 这一种校对方式。
-在 Doris 中，`SHOW COLLATION`
命令用于显示数据库中可用的字符集校对。校对是一组决定数据如何排序和比较的规则。这些规则会影响字符数据的存储和检索。Doris 目前主要支持
utf8_general_ci 这一种校对方式。
+## 语法
+
+```
+SHOW COLLATION
+```
+
+## 返回结果
`SHOW COLLATION` 命令返回以下字段：
@@ -39,21 +45,20 @@ under the License.
* Compiled：是否已编译
* Sortlen：排序长度
-### Example
+## 示例
```sql
-mysql> show collation;
-+-----------------+---------+------+---------+----------+---------+
-| Collation | Charset | Id | Default | Compiled | Sortlen |
-+-----------------+---------+------+---------+----------+---------+
-| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
-+-----------------+---------+------+---------+----------+---------+
+how collation;
```
-### Keywords
-
- SHOW, COLLATION
+```
++------------------+---------+------+---------+----------+---------+
+| Collation | Charset | Id | Default | Compiled | Sortlen |
++------------------+---------+------+---------+----------+---------+
+| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
++------------------+---------+------+---------+----------+---------+
+```
-### Best Practice
+## 注意事项
-使用 `SHOW COLLATION`
命令可以让你了解数据库中可用的校对规则及其特性。这些信息可以帮助确保你的字符数据按照预期的方式进行排序和比较。如果遇到字符比较或排序的问题，检查校对设置，确保它们符合你的预期，会是个很有帮助的操作。
+在 Doris 中，虽然兼容 MySQL 的设置 collation 的命令。但是实际并不会生效。执行时，永远会使用 utf8mb4_0900_bin
作为比较规则。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
index 500ce75c2f0..cad0aa2eb92 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
@@ -24,11 +24,17 @@ specific language governing permissions and limitations
under the License.
-->
-## SHOW-COLLATION
+## 描述
-### Description
+在 Doris 中，`SHOW COLLATION`
命令用于显示数据库中可用的字符集校对。校对是一组决定数据如何排序和比较的规则。这些规则会影响字符数据的存储和检索。Doris 目前主要支持
utf8mb4_0900_bin 这一种校对方式。
-在 Doris 中，`SHOW COLLATION`
命令用于显示数据库中可用的字符集校对。校对是一组决定数据如何排序和比较的规则。这些规则会影响字符数据的存储和检索。Doris 目前主要支持
utf8_general_ci 这一种校对方式。
+## 语法
+
+```
+SHOW COLLATION
+```
+
+## 返回结果
`SHOW COLLATION` 命令返回以下字段：
@@ -39,21 +45,20 @@ under the License.
* Compiled：是否已编译
* Sortlen：排序长度
-### Example
+## 示例
```sql
-mysql> show collation;
-+-----------------+---------+------+---------+----------+---------+
-| Collation | Charset | Id | Default | Compiled | Sortlen |
-+-----------------+---------+------+---------+----------+---------+
-| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
-+-----------------+---------+------+---------+----------+---------+
+how collation;
```
-### Keywords
-
- SHOW, COLLATION
+```
++------------------+---------+------+---------+----------+---------+
+| Collation | Charset | Id | Default | Compiled | Sortlen |
++------------------+---------+------+---------+----------+---------+
+| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
++------------------+---------+------+---------+----------+---------+
+```
-### Best Practice
+## 注意事项
-使用 `SHOW COLLATION`
命令可以让你了解数据库中可用的校对规则及其特性。这些信息可以帮助确保你的字符数据按照预期的方式进行排序和比较。如果遇到字符比较或排序的问题，检查校对设置，确保它们符合你的预期，会是个很有帮助的操作。
+在 Doris 中，虽然兼容 MySQL 的设置 collation 的命令。但是实际并不会生效。执行时，永远会使用 utf8mb4_0900_bin
作为比较规则。
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-reference/Show-Statements/SHOW-COLLATION.md
b/versioned_docs/version-2.0/sql-manual/sql-reference/Show-Statements/SHOW-COLLATION.md
index c06cc2bf2de..2ee85f0da45 100644
---
a/versioned_docs/version-2.0/sql-manual/sql-reference/Show-Statements/SHOW-COLLATION.md
+++
b/versioned_docs/version-2.0/sql-manual/sql-reference/Show-Statements/SHOW-COLLATION.md
@@ -24,11 +24,17 @@ specific language governing permissions and limitations
under the License.
-->
-## SHOW-COLLATION
+## Description
-### Description
+In Doris, the `SHOW COLLATION` command is used to display the character set
collations available in the database. A collation is a set of rules that
determine how data is sorted and compared. These rules affect the storage and
retrieval of character data. The content returned by this command is only for
compatibility with MySQL's behavior. It does not represent the list of
character set collations that Doris actually supports. Doris currently mainly
supports the proofreading method utf8m [...]
-In Doris, the `SHOW COLLATION` command is used to display the character set
collations available in the database. A collation is a set of rules that
determine how data is sorted and compared. These rules affect the storage and
retrieval of character data. Doris currently mainly supports the proofreading
method utf8_general_ci.
+## Syntax
+
+```
+SHOW COLLATION
+```
+
+## Result Fields
The `SHOW COLLATION` command returns the following fields:
@@ -42,7 +48,10 @@ The `SHOW COLLATION` command returns the following fields:
### Example
```sql
-mysql> show collation;
+show collation;
+```
+
+```
+-----------------+---------+------+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+-----------------+---------+------+---------+----------+---------+
@@ -50,10 +59,6 @@ mysql> show collation;
+-----------------+---------+------+---------+----------+---------+
```
-### Keywords
-
- SHOW, COLLATION
-
-### Best Practice
+### Notice
-Use the `SHOW COLLATION` command to give you an idea of the collations
available in the database and their properties. This information can help
ensure that your character data is sorted and compared as expected. If you have
problems comparing or sorting characters, it can be helpful to check your
collation settings to make sure they are what you expect.
+In Doris, although it is compatible with MySQL's commands for setting the
collation, the setting actually does not take effect. When executed, Doris will
always use utf8mb4_0900_bin as the comparison rule.
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
index 264d0c58532..51eb5e29d47 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
@@ -24,11 +24,17 @@ specific language governing permissions and limitations
under the License.
-->
-## SHOW-COLLATION
+## Description
-### Description
+In Doris, the `SHOW COLLATION` command is used to display the character set
collations available in the database. A collation is a set of rules that
determine how data is sorted and compared. These rules affect the storage and
retrieval of character data. Doris currently mainly supports the proofreading
method utf8mb4_0900_bin.
-In Doris, the `SHOW COLLATION` command is used to display the character set
collations available in the database. A collation is a set of rules that
determine how data is sorted and compared. These rules affect the storage and
retrieval of character data. Doris currently mainly supports the proofreading
method utf8_general_ci.
+## Syntax
+
+```
+SHOW COLLATION
+```
+
+## Result Fields
The `SHOW COLLATION` command returns the following fields:
@@ -42,18 +48,17 @@ The `SHOW COLLATION` command returns the following fields:
### Example
```sql
-mysql> show collation;
-+-----------------+---------+------+---------+----------+---------+
-| Collation | Charset | Id | Default | Compiled | Sortlen |
-+-----------------+---------+------+---------+----------+---------+
-| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
-+-----------------+---------+------+---------+----------+---------+
+show collation;
```
-### Keywords
-
- SHOW, COLLATION
+```
++------------------+---------+------+---------+----------+---------+
+| Collation | Charset | Id | Default | Compiled | Sortlen |
++------------------+---------+------+---------+----------+---------+
+| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
++------------------+---------+------+---------+----------+---------+
+```
-### Best Practice
+### Notice
-Use the `SHOW COLLATION` command to give you an idea of the collations
available in the database and their properties. This information can help
ensure that your character data is sorted and compared as expected. If you have
problems comparing or sorting characters, it can be helpful to check your
collation settings to make sure they are what you expect.
+In Doris, although it is compatible with MySQL's commands for setting the
collation, the setting actually does not take effect. When executed, Doris will
always use utf8mb4_0900_bin as the comparison rule.
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
b/versioned_docs/version-3.0/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
index 264d0c58532..51eb5e29d47 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-statements/Show-Statements/SHOW-COLLATION.md
@@ -24,11 +24,17 @@ specific language governing permissions and limitations
under the License.
-->
-## SHOW-COLLATION
+## Description
-### Description
+In Doris, the `SHOW COLLATION` command is used to display the character set
collations available in the database. A collation is a set of rules that
determine how data is sorted and compared. These rules affect the storage and
retrieval of character data. Doris currently mainly supports the proofreading
method utf8mb4_0900_bin.
-In Doris, the `SHOW COLLATION` command is used to display the character set
collations available in the database. A collation is a set of rules that
determine how data is sorted and compared. These rules affect the storage and
retrieval of character data. Doris currently mainly supports the proofreading
method utf8_general_ci.
+## Syntax
+
+```
+SHOW COLLATION
+```
+
+## Result Fields
The `SHOW COLLATION` command returns the following fields:
@@ -42,18 +48,17 @@ The `SHOW COLLATION` command returns the following fields:
### Example
```sql
-mysql> show collation;
-+-----------------+---------+------+---------+----------+---------+
-| Collation | Charset | Id | Default | Compiled | Sortlen |
-+-----------------+---------+------+---------+----------+---------+
-| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
-+-----------------+---------+------+---------+----------+---------+
+show collation;
```
-### Keywords
-
- SHOW, COLLATION
+```
++------------------+---------+------+---------+----------+---------+
+| Collation | Charset | Id | Default | Compiled | Sortlen |
++------------------+---------+------+---------+----------+---------+
+| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
++------------------+---------+------+---------+----------+---------+
+```
-### Best Practice
+### Notice
-Use the `SHOW COLLATION` command to give you an idea of the collations
available in the database and their properties. This information can help
ensure that your character data is sorted and compared as expected. If you have
problems comparing or sorting characters, it can be helpful to check your
collation settings to make sure they are what you expect.
+In Doris, although it is compatible with MySQL's commands for setting the
collation, the setting actually does not take effect. When executed, Doris will
always use utf8mb4_0900_bin as the comparison rule.
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
