on data semantics, which provides �→ more relevant search results. As one of the core functions of AI and �→ large language models (LLMs), vector search can be used in various �→ scenarios such as Retrieval-Augmented based on data semantics, which provides more relevant search results. As one of the core functions of AI and large language models (LLMs), vector search can be used in various scenarios such as Retrieval-Augmented 7’s default collation is utf8mb4_general_ci. 113 • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: ONLY_FULL_GROUP_BY,STRICT_

on data semantics, which provides �→ more relevant search results. As one of the core functions of AI and �→ large language models (LLMs), vector search can be used in various �→ scenarios such as Retrieval-Augmented based on data semantics, which provides more relevant search results. As one of the core functions of AI and large language models (LLMs), vector search can be used in various scenarios such as Retrieval-Augmented 7’s default collation is utf8mb4_general_ci. 108 • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: ONLY_FULL_GROUP_BY,STRICT_

com/zh/tidb/v8.4/vector-search-overview">向量搜索功能（ �→ 实验特性） 向量搜索是一种基于数据语义的搜索方法，可以提供更相关的搜索结果。作为 AI 和大语言模型 (LLM) �→ 的核心功能之一，向量搜索可用于检索增强生成 (Retrieval-Augmented Generation, RAG)、 �→ 语义搜索、推荐系统等多种场景。 @Lloyd-Pottiger @EricZequan @zimulala @JaySon-Huang @winoros @wk989898 向量搜索是一种基于数据语义的搜索方法，可以提供更相关的搜索结果。作为 AI 和大语言模型 (LLM) 的 核心功能之一，向量搜索可用于检索增强生成 (Retrieval-Augmented Generation, RAG)、语义搜索、推荐系统 等多种场景。 从 v8.4 字符集默认：utf8mb4_bin。 – MySQL 5.7 中 utf8mb4 字符集默认：utf8mb4_general_ci。 – MySQL 8.0 中 utf8mb4 字符集默认：utf8mb4_0900_ai_ci。 • SQL mode： – TiDB 默认：ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_

com/zh/tidb/v8.4/vector-search-overview">向量搜索功能（ �→ 实验特性） 向量搜索是一种基于数据语义的搜索方法，可以提供更相关的搜索结果。作为 AI 和大语言模型 (LLM) �→ 的核心功能之一，向量搜索可用于检索增强生成 (Retrieval-Augmented Generation, RAG)、 �→ 语义搜索、推荐系统等多种场景。 @Lloyd-Pottiger @EricZequan @zimulala @JaySon-Huang @winoros @wk989898 向量搜索是一种基于数据语义的搜索方法，可以提供更相关的搜索结果。作为 AI 和大语言模型 (LLM) 的 核心功能之一，向量搜索可用于检索增强生成 (Retrieval-Augmented Generation, RAG)、语义搜索、推荐系统 等多种场景。 从 v8.4 字符集默认：utf8mb4_bin。 – MySQL 5.7 中 utf8mb4 字符集默认：utf8mb4_general_ci。 – MySQL 8.0 中 utf8mb4 字符集默认：utf8mb4_0900_ai_ci。 • SQL mode： – TiDB 默认：ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_

09 SPECIFICS/ DRAWBACKS 06 CONTENT REPORT AUTHORS: FRANCISCO R. VASSALLO CONTRIBUTORS: RUCHI MITTAL AI IMAGES: DALL-E EDITOR: SUSANNE HELLE PRODUCT REVIEW - 2022 - TIDB ICONIC DATA, DATATECH ICONIC DATA

the default character set is utf8mb4, and the default �→ collation of utf8mb4 is utf8mb4_0900_ai_ci. TiDB v7.4.0 �→ adding support for this enhances compatibility with MySQL 8.0 so that �→ 5.7’s default collation is utf8mb4_general_ci. 80 • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: ONLY_FULL_GROUP_BY, �→ STRICT_TRANS_TABLES collation ascii ascii_general_ci ascii_bin latin1 latin1_swedish_ci latin1_bin utf8mb4 utf8mb4_0900_ai_ci utf8mb4_bin Way to avoid Set the collation manually, and do not rely on the client-side default

5.7’s default collation is utf8mb4_general_ci. 93 • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: ONLY_FULL_GROUP_BY, �→ STRICT_TRANS_TABLES collation ascii ascii_general_ci ascii_bin latin1 latin1_swedish_ci latin1_bin utf8mb4 utf8mb4_0900_ai_ci utf8mb4_bin Way to avoid Set the collation manually, and do not rely on the client-side default utf8_general_ci | utf8 | 33 | | Yes | 1 | | utf8_unicode_ci | utf8 | 192 | | Yes | 1 | | utf8mb4_0900_ai_ci | utf8mb4 | 255 | | Yes | 1 | | utf8mb4_0900_bin | utf8mb4 | 309 | | Yes | 1 | | utf8mb4_bin |

MySQL 5.7’s default collation is utf8mb4_general_ci. • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: ONLY_FULL_GROUP_BY,STRICT_ collation ascii ascii_general_ci ascii_bin latin1 latin1_swedish_ci latin1_bin utf8mb4 utf8mb4_0900_ai_ci utf8mb4_bin Way to avoid Set the collation manually, and do not rely on the client-side default utf8_general_ci | utf8 | 33 | | Yes | 1 | | utf8_unicode_ci | utf8 | 192 | | Yes | 1 | | utf8mb4_0900_ai_ci | utf8mb4 | 255 | | Yes | 1 | | utf8mb4_0900_bin | utf8mb4 | 309 | | Yes | 1 | | utf8mb4_bin |

MySQL 5.7’s default collation is utf8mb4_general_ci. • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: ONLY_FULL_GROUP_BY,STRICT_ collation ascii ascii_general_ci ascii_bin latin1 latin1_swedish_ci latin1_bin utf8mb4 utf8mb4_0900_ai_ci utf8mb4_bin Way to avoid Set the collation manually, and do not rely on the client-side default utf8_general_ci | utf8 | 33 | | Yes | 1 | | utf8_unicode_ci | utf8 | 192 | | Yes | 1 | | utf8mb4_0900_ai_ci | utf8mb4 | 255 | | Yes | 1 | | utf8mb4_0900_bin | utf8mb4 | 309 | | Yes | 1 | | utf8mb4_bin |

7’s default collation is utf8mb4_general_ci. 108 • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: ONLY_FULL_GROUP_BY,STRICT_ collation ascii ascii_general_ci ascii_bin latin1 latin1_swedish_ci latin1_bin utf8mb4 utf8mb4_0900_ai_ci utf8mb4_bin Way to avoid Set the collation manually, and do not rely on the client-side default utf8_general_ci | utf8 | 33 | | Yes | 1 | | utf8_unicode_ci | utf8 | 192 | | Yes | 1 | | utf8mb4_0900_ai_ci | utf8mb4 | 255 | | Yes | 1 | | utf8mb4_0900_bin | utf8mb4 | 309 | | Yes | 1 | | utf8mb4_bin |