[MySQL] length() vs char_length()
Written on LENGTH function returns the length of the string measured in bytes.
CHAR_LENGTH() returns the length of the string measured in characters.
1. LENGTH() : 길이를 bytes로 나타낸다.
SELECT LENGTH(‘한글’) -> 6
SELECT LENGTH(‘abc’) -> 3
2. CHAR_LENGTH() : 글자의 수를 나타낸다.
SELECT CHAR_LENGTH(‘한글’) -> 2
SELECT CHAR_LENGTH(‘abc’) -> 3
3. BIT_LENGTH() : 길이를 bit로 나타낸다.
SELECT BIT_LENGTH(‘한글a’) -> 56
SELECT BIT_LENGTH(‘한글’) -> 48
영준 (=hax0r)
https://www.hax0r.info
I am a passionate back-end developer always in hunger of learning new things and sharing what i have learned. who loves challenges, newest technologies and programming at all.