SQL 2005中的SQL SERVER 2005 NVARCHAR [英] SQL SERVER 2005 NVARCHAR in SQL 2005
本文介绍了SQL 2005中的SQL SERVER 2005 NVARCHAR的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
谁能告诉我SQL 2005中NVARCHAR的最大可能长度是多少?
can any one tell me what is max possible length of NVARCHAR in SQL 2005
推荐答案
http://msdn.microsoft.com/en-us/library/ms186939.aspx[^]
The maximum storage size for NVARCHAR(MAX) is also 2^31-1 bytes (2,147,483,647 bytes or 2GB - 1 bytes). The storage size, in bytes, is two times the number of characters entered + 2 bytes. The data entered can be 0 characters in length. Since each Unicode character in an NVARCHAR data type uses two bytes, the maximum length for an NVARCHAR(MAX) data type is 1,073,741,822.
这篇关于SQL 2005中的SQL SERVER 2005 NVARCHAR的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
