Capacity limits for dedicated SQL pool in Azure Synapse Analytics

Question

As per the information in Microsoft Learn on "Capacity limits for dedicated SQL pool in Azure Synapse Analytics", Database Objects section;
Dependent on column data type. Limit is 8000 for char data types, 4000 for nvarchar, or 2 GB for MAX data types; is there any way to store more than 4000 (nvarchar) characters using data type nvarchar(max)?

Answer 1

Hello @Shweta Barhate ,

Welcome to the Microsoft Q&A platform.

Character data types that are either fixed-size, nchar, or variable-size, nvarchar.

nvarchar [ ( n | max ) ]
Variable-size string data. n defines the string size in byte-pairs and can be a value from 1 through 4,000. max indicates that the maximum storage size is 2^30-1 characters (2 GB). The storage size is two times n bytes + 2 bytes.

Here is a great Stack Overflow forum posts which addressing similar issue: SQL NVARCHAR and VARCHAR Limits and How does SQL Server store more than 4000 characters in NVARCHAR(max)?.

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.