dongluo-smile opened a new issue, #40899: URL: https://github.com/apache/doris/issues/40899
### Discussed in https://github.com/apache/doris/discussions/40873 <div type='discussions-op-text'> <sup>Originally posted by **dongluo-smile** September 14, 2024</sup> 通过SHOW CHARACTER SET;命令查看显示 | Charset | Description | Default collation | Maxlen | ----- | ----- | ----- | ----- | | utf8mb4 | UTF-8 Unicode | utf8mb4_0900_bin | 4 | 通过SHOW COLLATION;命令查看显示 | Collation | Charset | Id | Default | Compiled | Sortlen | ----- | ----- | ----- | ----- | ----- | ----- | | utf8mb4_0900_bin | utf8mb4 | 309 | Yes | Yes | 1 | | utf8mb3_general_ci | utf8mb3 | 33 | Yes | Yes | 1 | **问题：utf8mb4_0900_bin排序规则会导致查询数据时区分大小写，如（'ABC' != 'abc'）** **期望：将Default collation修改为utf8mb4_general_ci，查询数据不区分大小写，如（'ABC' == 'abc'）** **修改fe.conf和be.conf配置文件，添加default_character_set = utf8mb4 default_collation = utf8mb4_general_ci并重启，发现没有任何作用。** **请问各位大神，如何配置才能让其生效？**</div> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
