首页 > 其他 > 详细

LENGTH() CHAR_LENGTH()

时间:2016-12-23 14:22:25      阅读:270      评论:0      收藏:0      [点我收藏+]

http://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_length

LENGTH(str)

Returns the length of the string str, measured in bytes. A multibyte character counts as multiple bytes. This means that for a string containing five 2-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5.

 

CHAR_LENGTH(str)

Returns the length of the string str, measured in characters. A multibyte character counts as a single character. This means that for a string containing five 2-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5.

LENGTH() CHAR_LENGTH()

原文:http://www.cnblogs.com/yuanjiangw/p/6214335.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!