MySQL: LENGTH() is incorrect. Important difference between CHAR_LENGTH() vs LENGTH()
Using LENGTH() is incorrect. The question is asking for the number of characters used in the content. LENGTH() returns the length of the string measured in byte
Using ```LENGTH()``` is incorrect. The question is asking for ```the number of characters used in the content```. ```LENGTH()``` returns the length of the string measured in bytes. ```CHAR_LENGTH()``` returns the length of the string measured in characters.\n\n```sql\nSELECT tweet_id\nFROM Tweets\nWHERE CHAR_LENGTH(content) > 15\n```\n\nReference:\nhttps://stackoverflow.com/questions/1734334/mysql-length-vs-char-length?rq=1\n\n* LENGTH() returns the length of the string measured in bytes.\n* CHAR_LENGTH() returns the length of the string measured in characters.\n\nThis is especially relevant for Unicode, in which most characters are encoded in two bytes, or UTF-8, where the number of bytes varies. \n\nExample:\n```sql \nSELECT LENGTH(\'\u20AC\')  # is equal to 3\n```\n```sql \nSELECT CHAR_LENGTH(\'\u20AC\') # is equal to 1\n```\n\n*Important Note:* Using ```LENGTH()``` will pass the testcases. If the testcases included characters such as ```\u20AC``` then it would fail as shown in the examples above.
[]