What is the difference between CHAR_LENGTH and LENGTH in MySQL? - Mysql Views : 228
Tagged in : Mysql
0 0
Send mail

What is the difference between CHAR_LENGTH and LENGTH in MySQL?


CHAR_LENGTH, as the name suggests, returns the number of characters / character count. The LENGTH returns the number of bytes / bytes count. To count the Latin characters, both lengths are the same. To count Unicode and other encodings, the lengths are different.
By Geethalakshmi, On - 2010-09-29



    Login to add Comments .