Home » MCQs » SQL MCQs » SQL Data Types MCQs

What is the difference between nchar and nvarchar?

15. What is the difference between nchar and nvarchar?

1. nchar is fixed and nvarchar is variable.
2. nchar is variable and nvarchar is fixed.
3. nchar has the maximum size of 4000 characters and nvarchar has the maximum size of 8000 characters.
4. nchar has the maximum size of 800 characters and nvarchar has the maximum size of 4000 characters.

Answer: A) nchar is fixed and nvarchar is variable.

Explanation:

nchar is fixed and nvarchar is variable width Unicode string data type.