استفاده از nvarchar(max) vs NText در sql server

The advantages are that you can use functions like LEN and LEFT on nvarchar(max) and you cannot do that against ntext and text. It is also easier to work with nvarchar(max) than text where you had to use WRITETEXT and UPDATETEXT.

Also, text, ntext, etc., are being deprecated (http://msdn.microsoft.com/en-us/library/ms187993.aspx)

حداکثر سایز nvarchar max:

Max. capacity is 2 GByte of space - so you're looking at just over 1 billion 2-byte characters that will fit into a NVARCHAR(MAX) field.

Using the other answer's more detailed numbers, you should be able to store

(2^31-1)/2=1'037'741'823 double-byte characters 1 billion,37 million,741 thousand and823 characters to be precise

in your NVARCHAR(MAX) column (unfortunately, that last half character is wasted...)

سایز متغیر ntext:
ntext

Variable-length Unicode data with a maximum string length of 2^30 - 1 (1,073,741,823) bytes. Storage size, in bytes, is two times the string length that is entered. The ISO synonym for ntext is national text.

text

Variable-length non-Unicode data in the code page of the server and with a maximum string length of 2^31-1 (2,147,483,647). When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes. Depending on the character string, the storage size may be less than 2,147,483,647 bytes.

image

Variable-length binary data from 0 through 2^31-1 (2,147,483,647) bytes.

لینک منبع
لینک منبع
لینک منبع

استفاده از nvarchar(max) vs NText در sql server

مطالب مشابه :

مقایسه کریستال ریپورت و استیمول سافت (ابزارهای گزارشگیری در دات نت)

طريقه استفاده از Crystal Report

دانلود کتاب نحوه کار با کریستال ریپورت در سی شارپ

استفاده از nvarchar(max) vs NText در sql server

توصیح مبحث کریستال ریپورت

مجموعه کامل آموزش برنامه نویسی سی شارپ پکیج دو

برنامه نویسی