Pages

Wednesday, June 4, 2008

difference between varchar and nvarchar

The difference is that nvarchar is used to store unicode data, which is used to store multilingual data in your database tables. Other languages have an extended set of character codes that need to be saved and this datatype allows for this extension. If your database will not be storing multilingual data you should use the varchar datatype instead. The reason for this is that nvarchar takes twice as much space as varchar, this is because of the need to store the extended character codes for other languages

2 comments:

Kiran Kumar said...

Nice post sir i learn lot lot lot

Vijaya Kadiyala said...

Hi,
Thanks for visiting my site, Please visit for more information.