Back again with a new SQL blog 🚀 This time, I explained one of the most confusing MySQL concepts for beginners: LENGTH() vs CHAR_LENGTH() Most people think both functions are the same… until emojis ...

LENGTH(str) mysql function returns the length of the string str, measured in bytes. This function counts a multibyte character as multiple bytes. hence it means for a string containing 4(four) 2-byte ...