Wednesday, February 26, 2014

Sqlserver nvarchar ntext difference

Thanks to Graeme for asking an interesting question about the difference between nvarchar and varchar. Since my first language can’t be stored in ACSII, I know nvarchar is the way to go.
Further reading on nvarchar(max) prompted us to think the differences between nvarchar and ntext, and we found the following in MSDN. 

ntext , text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.

Don’t panic, further version doesn’t include SQLServer 2012.  Read more here:

16 comments:

Unknown said...


I read your articles very excellent and the i agree our all points because all is very good information provided this through in the post. It is very helpful for me. Keep blogging like this. Thanks.


SAP training in Chennai

Teena said...

Thank you for your post. This was really an appreciating one. You done a good job. Keep on blogging like this unique information with us.


Digital Marketing Training in Chennai

Ravi said...


this is really too useful and have more ideas from yours. keep sharing many techniques. eagerly waiting for your new blog and useful information. keep doing more.
PHP Training in Chennai Adyar

Unknown said...

A debt of gratitude is in order for requiring some serious energy share this post. It is truly useful. I propose to visit this site to my group members. Please continue posting this way.
SAS Training in Chennai | SAS Course in Chennai

Unknown said...

Nice post. Very interesting to read. Thank you for Sharing.
erp providers in chennai

Anonymous said...

Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
Authorized ipad service center in Chennai | ipad service center in chennai | Authorized ipad service center in Chennai | ipad service center in chennai | ipad service center in chennai | 100% genuine apple parts

best coursework writing service said...

Zhen has a great experience, I appreciated, and your way to write a blog is also quite good, many people got much help from this blog.

jack henry said...

That is really nice Continue your wonderful work. I appreciate you giving this information. The information was genuinely fascinating. You make an excellent point, and I appreciate you sharing this unique knowledge! Your site is excellent, and I hope to see more of it in the future. I appreciate you sharing your expertise! Actually, I am a student, and while looking for a service to help me with my assignments, I discovered a fantastic academic essay writing help that is Excellent for Every Student.

ilajmualja52 said...

That is very admirable. Keep up the fantastic work. Thank you for sharing this information. It was actually fascinating stuff. You have a great point, and I value you giving this special information.Its time to avail of the service of doctors-child-specialist-lahore,click Here .

Jonny Dave said...

Such a great blog. Thank you for this type of sharing content with us. I have achive to great experience to read this blog. I will refer this with others for visit this site or blog for more information. Now it's time to avail taxi milwaukee for more information.

John Hardy said...

In this blog you tell about very good difference between nvarchar and varchar. Hope this one is very good for us. Thanks for sharing this article. Now it's time to avail Shutter repair near me for more information.

Ava James said...

In this blog you distinctly difference between two things, which is quite good. I really got a lot of information in this article. Thanks for sharing this article with us. Read more https://www.greatytene.com/shopfitters-in-birmingham-can-help-you-grow-your-business-quickly/.

Ava James said...

The article is very helpful for us. In this article you tell about the difference between nvarchar and varchar. Thanks for sharing this article. Now its time to avail Limo service West Palm Beach for more information.

Sophia Daniel said...

Great article! In this article we clearly see the difference. I appreciated the way you write this article. Thanks for sharing with us. Now its time to avail Limo service West Palm Beach for more information.

Maya Jack said...

This is very useful difference I have ever seen on any website. I like the points and the content you shared in this article. Hope so you further shared with us. Thankyou. Now its time to avail Best Towing Services in Lutz FL for more information.

Markwillium said...

Amazing experience with Microsoft Azure and DevOps you have. You are very skilled. Thanks for sharing the valuable information that you mentioned in this blog. Now it's time to avail Jupiter Florida Airport for more information.