469,299 Members | 2,050 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

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 5915
yahya30
10
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
Jun 2 '07 #2
@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 ........
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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.