字段值大小写敏感问题?

Viewed 19

问题1:Doris如何设置字段值大小写不敏感?
问题2:collation如何设置为utf8mb3_general_ci?(是要永久的)
若把变量设置utf8mb3_general_ci,也没效的。
问题3:若没法解决字段值大小写敏感问题,未来有ISSUE解决吗?

以下是简单查看

show collation


utf8mb4_0900_bin utf8mb4 309 Yes Yes 1
utf8mb3_general_ci utf8mb3 33 Yes Yes 1

SHOW VARIABLES LIKE 'collation%'


Variable_name Value Default_Value Changed
collation_connection utf8mb4_0900_bin utf8mb4_0900_bin 0
collation_database utf8mb4_0900_bin utf8mb4_0900_bin 0
collation_server utf8mb4_0900_bin utf8mb4_0900_bin 0

1 Answers