472,125 Members | 1,477 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,125 software developers and data experts.

Difference between varchar & nvarchar

111 100+
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
May 17 '07 #1
2 6025
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,
Jun 2 '07 #2
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 ........
Jan 6 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Vani Kancherlapalli | last post: by
4 posts views Thread by stuckish | last post: by
5 posts views Thread by haidani | last post: by
5 posts views Thread by Jay | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.