Mega Code Archive

 

Categories / MySQL Tutorial / String Functions

 

LENGTH(str)

For a string containing five two-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5. OCTET_LENGTH() is a synonym for LENGTH(). SELECT LENGTH('text'); mysql>