mysql 中的 char_length() 或 character_length() 字符串函数用于检索指定字符串的长度。该函数只会计算字符数，而忽略字符是单字节还是多字节。
示例mysql> select char_length('new delhi');+--------------------------+| char_length('new delhi') |+--------------------------+| 9 |+--------------------------+1 row in set (0.00 sec)mysql> select char_length('newdelhi');+-------------------------+| char_length('newdelhi') |+-------------------------+| 8 |+-------------------------+1 row in set (0.00 sec)mysql> select character_length('newdelhi');+------------------------------+| character_length('newdelhi') |+------------------------------+| 8 |+------------------------------+1 row in set (0.00 sec)mysql> select character_length('new delhi');+-------------------------------+| character_length('new delhi') |+-------------------------------+| 9 |+-------------------------------+1 row in set (0.00 sec)
以上就是mysql中如何获取指定字符串的长度？的详细内容。