Difference between varchar & nvarchar

[bharathreddy]

Here i will show the differences between nvarchar and varchar:

The difference is that nvarchar is used to store unicode data, which is used to store multilingual data in the database tables. Other languages have an extended set of character codes that need to be saved and this datatype allows for this extension. If the database will not be storing multilingual data we should use the varchar database 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.


Thanks & Reg
Bharath Reddy VasiReddy
eXensys Software Solutions Ltd

[yahya30]

Hi,
Could you please explain what do you mean exactly by "multilingual data in the database tables" and "extended set of character codes" in order to make your post more understandable.


Kind regards,
Yahya

[Abhijith Rohit]

@yahya30
Hi Yahya,
multilingual means multiple languages and multilingual data means data in diiferent languages so by default SQL supports English and if you want to use any other language than that of english you need to use Nvarchar instead of vrchar ....here the n store the unicode value for that particular language .....the size of nvarchar is double of the varchar ........