This is an automated email from the ASF dual-hosted git repository.
morningman 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 a3b4327375c2 [docs] Explain STRING aliases and metadata display names
(#4620)
a3b4327375c2 is described below
commit a3b4327375c2a4872111bb11b89da03e1be90097
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Fri Nov 13 08:03:09 2026 +0800
[docs] Explain STRING aliases and metadata display names (#4620)
Explain why STRING appears as text in SHOW CREATE TABLE and DESC,
varchar in MySQL-compatible DATA_TYPE metadata, and string in Doris
COLUMN_TYPE metadata. Document how to distinguish it from VARCHAR.
Fixes #3883
Versions and languages: dev, 4.x and 3.x; English and Chinese.
Source verification:
- Verified branch-3.0, branch-3.1, branch-4.0, branch-4.1 and master
- Nereids DataType.fromString maps text and string to StringType
- ScalarType.toSql returns text for PrimitiveType.STRING
- SchemaColumnsScanner maps STRING DATA_TYPE to varchar and COLUMN_TYPE
to string
Validation:
- Compared parser, type renderer and schema scanner across all active
source branches
- Checked English and Chinese explanation tables agree in all six copies
- git diff --check
Review:
- Goal: correct the reported documentation issue; the changed content
directly addresses it.
- Scope: targeted documentation edits.
- Information architecture: active version and locale counterparts
inspected; archived snapshots unchanged.
- Navigation: no paths, slugs, anchors or sidebar entries changed.
- Frontend/build: no framework, styling or build-script changes.
- Validation limits: no live Doris execution or full website build
performed.
- Other concerns: Added headings are new anchors; existing paths,
anchors and navigation remain valid. No additional concerns found.
Co-authored-by: morningman <[email protected]>
---
.../basic-element/sql-data-types/string-type/STRING.md | 12 ++++++++++++
.../basic-element/sql-data-types/string-type/STRING.md | 12 ++++++++++++
.../basic-element/sql-data-types/string-type/STRING.md | 12 ++++++++++++
.../basic-element/sql-data-types/string-type/STRING.md | 12 ++++++++++++
.../basic-element/sql-data-types/string-type/STRING.md | 12 ++++++++++++
.../basic-element/sql-data-types/string-type/STRING.md | 12 ++++++++++++
6 files changed, 72 insertions(+)
diff --git a/docs/sql-manual/basic-element/sql-data-types/string-type/STRING.md
b/docs/sql-manual/basic-element/sql-data-types/string-type/STRING.md
index 5e6e0398b2fa..e9a585415e96 100644
--- a/docs/sql-manual/basic-element/sql-data-types/string-type/STRING.md
+++ b/docs/sql-manual/basic-element/sql-data-types/string-type/STRING.md
@@ -14,3 +14,15 @@ Note: Variable length strings are stored in UTF-8 encoding,
so usually English c
### keywords
STRING
+
+### Type aliases and metadata display
+
+`STRING` and `TEXT` define the same Doris type. Different interfaces display
that type differently:
+
+| Interface | Display for a `STRING` column |
+| --- | --- |
+| `SHOW CREATE TABLE` and `DESC` | `text` |
+| `information_schema.columns.DATA_TYPE` | `varchar`, for MySQL compatibility |
+| `information_schema.columns.COLUMN_TYPE` | `string` |
+
+These names do not change the stored type or its length limit. To distinguish
a Doris `STRING` column from a length-limited `VARCHAR` column in metadata,
check `COLUMN_TYPE`.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/string-type/STRING.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/string-type/STRING.md
index 680274179711..7cdc529729b5 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/string-type/STRING.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/string-type/STRING.md
@@ -19,3 +19,15 @@ STRING
## keywords
STRING
+
+### 类型别名与元数据显示
+
+`STRING` 和 `TEXT` 定义的是同一种 Doris 类型。不同接口对该类型的显示名称不同：
+
+| 接口 | `STRING` 列的显示名称 |
+| --- | --- |
+| `SHOW CREATE TABLE` 和 `DESC` | `text` |
+| `information_schema.columns.DATA_TYPE` | `varchar`，用于兼容 MySQL |
+| `information_schema.columns.COLUMN_TYPE` | `string` |
+
+这些显示名称不会改变实际存储类型或长度限制。通过元数据区分 Doris `STRING` 列与有长度限制的 `VARCHAR` 列时，请查看
`COLUMN_TYPE`。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
index 90e9560a3c9b..503e8f66645d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
@@ -20,3 +20,15 @@ STRING
## keywords
STRING
+
+### 类型别名与元数据显示
+
+`STRING` 和 `TEXT` 定义的是同一种 Doris 类型。不同接口对该类型的显示名称不同：
+
+| 接口 | `STRING` 列的显示名称 |
+| --- | --- |
+| `SHOW CREATE TABLE` 和 `DESC` | `text` |
+| `information_schema.columns.DATA_TYPE` | `varchar`，用于兼容 MySQL |
+| `information_schema.columns.COLUMN_TYPE` | `string` |
+
+这些显示名称不会改变实际存储类型或长度限制。通过元数据区分 Doris `STRING` 列与有长度限制的 `VARCHAR` 列时，请查看
`COLUMN_TYPE`。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
index 680274179711..7cdc529729b5 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
@@ -19,3 +19,15 @@ STRING
## keywords
STRING
+
+### 类型别名与元数据显示
+
+`STRING` 和 `TEXT` 定义的是同一种 Doris 类型。不同接口对该类型的显示名称不同：
+
+| 接口 | `STRING` 列的显示名称 |
+| --- | --- |
+| `SHOW CREATE TABLE` 和 `DESC` | `text` |
+| `information_schema.columns.DATA_TYPE` | `varchar`，用于兼容 MySQL |
+| `information_schema.columns.COLUMN_TYPE` | `string` |
+
+这些显示名称不会改变实际存储类型或长度限制。通过元数据区分 Doris `STRING` 列与有长度限制的 `VARCHAR` 列时，请查看
`COLUMN_TYPE`。
diff --git
a/versioned_docs/version-3.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
b/versioned_docs/version-3.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
index 0cad8b8c7a5f..1638b6f86ff8 100644
---
a/versioned_docs/version-3.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
+++
b/versioned_docs/version-3.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
@@ -14,3 +14,15 @@ Note: Variable length strings are stored in UTF-8 encoding,
so usually English c
### keywords
STRING
+
+### Type aliases and metadata display
+
+`STRING` and `TEXT` define the same Doris type. Different interfaces display
that type differently:
+
+| Interface | Display for a `STRING` column |
+| --- | --- |
+| `SHOW CREATE TABLE` and `DESC` | `text` |
+| `information_schema.columns.DATA_TYPE` | `varchar`, for MySQL compatibility |
+| `information_schema.columns.COLUMN_TYPE` | `string` |
+
+These names do not change the stored type or its length limit. To distinguish
a Doris `STRING` column from a length-limited `VARCHAR` column in metadata,
check `COLUMN_TYPE`.
diff --git
a/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
b/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
index 5e6e0398b2fa..e9a585415e96 100644
---
a/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
+++
b/versioned_docs/version-4.x/sql-manual/basic-element/sql-data-types/string-type/STRING.md
@@ -14,3 +14,15 @@ Note: Variable length strings are stored in UTF-8 encoding,
so usually English c
### keywords
STRING
+
+### Type aliases and metadata display
+
+`STRING` and `TEXT` define the same Doris type. Different interfaces display
that type differently:
+
+| Interface | Display for a `STRING` column |
+| --- | --- |
+| `SHOW CREATE TABLE` and `DESC` | `text` |
+| `information_schema.columns.DATA_TYPE` | `varchar`, for MySQL compatibility |
+| `information_schema.columns.COLUMN_TYPE` | `string` |
+
+These names do not change the stored type or its length limit. To distinguish
a Doris `STRING` column from a length-limited `VARCHAR` column in metadata,
check `COLUMN_TYPE`.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
