DATALENGTH (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
This function returns the number of bytes used to represent any expression.
Note
To return the number of characters in a string expression, use the LEN function.
Transact-SQL syntax conventions
Syntax
DATALENGTH ( expression )
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Arguments
expression
An expression of any data type.
Return types
bigint if expression has an nvarchar(max), varbinary(max), or varchar(max) data type; otherwise int.
Remarks
DATALENGTH
becomes really helpful when used with data types that can store variable-length data, such as:
- image
- ntext
- nvarchar
- text
- varbinary
- varchar
For a NULL value, DATALENGTH
returns NULL.
Note
Compatibility levels can affect return values. See ALTER DATABASE Compatibility Level (Transact-SQL) for more information about compatibility levels.
Note
Use the LEN to return the number of characters encoded into a given string expression, and DATALENGTH to return the size in bytes for a given string expression. These outputs may differ depending on the data type and type of encoding used in the column. For more information on storage differences between different encoding types, see Collation and Unicode Support.
Examples
This example finds the length of the Name
column in the Product
table:
USE AdventureWorks2022
GO
SELECT length = DATALENGTH(EnglishProductName), EnglishProductName
FROM dbo.DimProduct
ORDER BY EnglishProductName;
GO
See also
LEN (Transact-SQL)
CAST and CONVERT (Transact-SQL)
Data Types (Transact-SQL)
System Functions (Transact-SQL)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho