what is difference between text and ntext datatype in Sql server?

Posted by Bageshkumarbagi under Sql Server on 11/7/2012 | Points: 10 | Views : 28847 | Status : [Member] | Replies : 4
hi
what is difference between text and ntext datatype in Sql server?

Thanks,
Bagesh Kumar Singh
Mark as answer if you have been satisfied



Responses

Posted by: Sourabh07 on: 11/7/2012 [Member] Starter | Points: 25

Up
0
Down
hi..

please refer to the following link....it will help you..

http://msdn.microsoft.com/en-us/library/ms187993.aspx

Sourabh07

Bageshkumarbagi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saratvaddilli on: 11/7/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
The major difference between text and ntext : ntext is variable length with unicode data i.e it will support multiple languages and and its storage size will be double the actual size .

Please avoid text and ntext and go through the link provided in the above post

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Bageshkumarbagi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bageshkumarbagi on: 11/7/2012 [Member] Starter | Points: 25

Up
0
Down
ok.

Thanks,
Bagesh Kumar Singh
Mark as answer if you have been satisfied

Bageshkumarbagi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saratvaddilli on: 11/8/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi bageshKumarbagi
if it helps you please mark as answer that will help some other who searching for the same

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Bageshkumarbagi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response