The difference between Len and datalength in SQL

Solving string length problems in SQL

One, LEN (Param) to find the length of the string

Datalength (param) to find the byte length of the string

Two, Len does not return the length of the space after the text and Datalenth is different

　　

Third, for ntext, text, image such data types to find the length of datalenth is very useful.

Because: 1, the corresponding content of these data types is variable. Datalength calculate the number of bytes in the occupied memory

2, the above three data types Len is unable to calculate.

The above content is only for the study use, if has the different opinion, promptly pointed out, studies together

The difference between Len and datalength in SQL