Difference between LEN () and DATALENGTH () in mySQL _ MySQL

Difference between LEN () and DATALENGTH () in mySQL bitsCN.com

LEN (string_expression) parameter: string to be calculated
ReturnsCharacter Count, Which does not contain trailing spaces.
If the expression data type is varchar (max), nvarchar (max), or varbinary (max), it is bigint; otherwise, it is int.
Ntext fields cannot be calculated.

DATALENGTH (expression) parameter: any data type expression
ReturnsBytes.
If the expression data type is varchar (max), nvarchar (max), or varbinary (max), bigint is returned; otherwise, int is returned.
DATALENGTH is particularly useful for varchar, varbinary, text, image, nvarchar, and ntext data types because these data types can store variable-length data.
The result of null datalength is NULL.

BitsCN.com