CHAR_LENGTH includes leading and trailing blanks and the string-termination character LENGTH excludes trailing blanks and the string-termination character. It does not exclude leading blanks.
MySQL CHAR_LENGTH and LENGTH - September 30, 2009 at 18:00 pm by Vidya SagarWhat 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.