Difference Between varchar and nvarchar datatype?

Answer Posted / muhammadrashidmughal

The difference in varchar and nvarchar datatypes is
simple. Nvarchar stores UNICODE data. If you have
requirements to store UNICODE or multilingual data,
nvarchar is your choice. Varchar stores ASCII data and
should be your data type of choice for normal use

Is This Answer Correct ?    37 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain extended properties

560


Which is the latest version of sql server and when it is released?

541


What is a Join and explain its types?

581


Explain how to use linked server?

563


How would you go about developing a ssrs report?

110






What is correlated subquery in sql server?

557


When would you prefer to have a minimum number of indexes?

503


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1094


What is normalization according to you and explain its different levels?

522


What is the purpose of self join?

499


What is a deadlock and what is a live lock?

571


Why would you use sql agent?

732


What authentication modes does sql server support?

596


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

703


Can we store videos inside the sql server table?

517