Apache Doris 中文技术论坛
Questions Tags Users Badges

length函数返回不是字节数

Asked Feb 7, 2025 Modified Feb 8, 2025
Viewed 110
2.1 functions

中国的utf8编码,字节数不应该是6吗?文档中说是返回字节数,例子中返回了字符数
image.png

edited Feb 8, 2025
jason3
asked Feb 7, 2025
3 Answers

https://github.com/apache/doris/pull/46523
已修复,请更新到2.1.8再测试

edited Jan 1, 1970
zclllyybb551
answered Feb 7, 2025

version:2.0.9
image.png

edited Jan 1, 1970
xxxl20
answered Feb 7, 2025

这个是之前搞的常量折叠有问题,导致文档写错了

https://github.com/apache/doris/pull/40947

mysql> select length("中国");
+------------------+
| length('中国')   |
+------------------+
|                6 |
+------------------+
edited Jan 1, 1970
11
answered Feb 7, 2025
Related Questions
集群规划问题
1 answers
多台BE节点异常宕机
1 answers
doris2.0.7集群迁移到新搭建的doris2.1.11集群
1 answers
2.1.11版本,新优化器,执行计划隐式类型转换丢失精度,导致数据不一致
1 answers
doris配置ranger鉴权后,单表查询可以看到脱敏效果,但是关联查询后就失效了
2 answers
doris 2.x 同步到哪个版本的doris 最稳定
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2026 Apache Doris 中文技术论坛.