differences between varchar and nvarchar?
differences between varchar and nvarchar?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Iftikar HussainPosted Jul 14, 2013, 5:10 AM
Here it is
nvarchar can store Unicode characters where varchar cannot store Unicode characters.
Regards,
Iftikar
Jignesh TrivediPosted Jul 15, 2013, 12:09 AM
hi,
nVarchar datatype can hold any unicode data whereas varchar is restricated to 8 bit code page.
In nvarchar, Database collation dependents for comparision whereas in varchar database collation determine which code page the dat is storing.
Please refer
http://www.mindstick.com/Blog/479/Difference%20between%20char%20var
hope this will help you.
Sanjeeb LenkaPosted Jul 14, 2013, 5:05 PM
http://sqlhints.com/2011/12/23/difference-between-varchar-and-nvarchar/