What is the difference between varchar and nvarchar?

Posted by Bageshkumarbagi under Sql Server on 11/6/2012 | Points: 10 | Views : 1442 | Status : [Member] | Replies : 2
hi
What is the difference between varchar and nvarchar. give some example. where we use ntext,text,nchar,varchar and nvarchar.

Thanks,
Bagesh Kumar Singh
Mark as answer if you have been satisfied



Responses

Posted by: Saratvaddilli on: 11/7/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
char and varchar :

char allocates fixed size for storing data and varchar is of variable length . char and varchar stores only non-unicode data.

nchar and varchar:
The "n" at the beginning signifies a double byte character to store Unicode data. Use that if you need to handle multiple languages, or languages with double byte characters like Chinese.
check this link , you might have a good idea
http://beginsql.wordpress.com/2011/12/23/difference-between-varchar-and-nvarchar/

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Bageshkumarbagi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Naraayanan on: 11/7/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,
@Saratvaddilli
Nice Explanation. Nice Blog .

Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Bageshkumarbagi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response