SQL Server DATALENGTH and LEN functions

Previous Next

See Also

On SQL Server, the DATALENGTH(expression) function returns the number of bytes used to represent the expression. The LEN(expression) function returns the number of characters of the expression, excluding trailing blanks.

In USoft Version 7.0 (NON-UNICODE), there was no difference between these functions.

In USoft Version 8 (UNICODE), the LENGTH() function in a constraint is translated to the SQL Server LEN() function, and the DATALENGTH() function is translated to the DATALENGTH() function.