mybatis5.0 utf8mb4_general_ci
时间: 2023-08-21 09:04:55 浏览: 108
在MyBatis 5.0中,"utf8mb4_general_ci"是一种字符集,它使用了UTF-8编码,并且采用了utf8mb4_unicode_ci的排序规则。这个排序规则会考虑字符的Unicode编码和Plane的概念。Unicode字符被分为17个planes,每个plane包含65536个代码点。Plane 0(BMP)包含了世界上各种语言与标记中最常用的字符,而Plane 1(SMP)则包含了表情符号、字母与数学符号、音乐符号、太玄经(太极符号)、装饰符号、扑克牌、麻将符号、箭头扩展和一些世界上各种语言不太常用的文字等等。所以在"utf8mb4_general_ci"字符集中,可以支持更多的字符范围和Unicode编码。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [MySQL字符编码的讨论:如何处理emoji等4字节的Unicode字符 - utf8mb4 vs. utf8 Collations](https://blog.csdn.net/dduhmy/article/details/42044243)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *3* [如何处理emoji等4字节的Unicode字符 - utf8mb4 vs. utf8 Collations](https://blog.csdn.net/codepython/article/details/50403252)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文