LearnThatStack Ace your next interview
SQL Server · question
Question 3 of 47

What is the difference between VARCHAR and NVARCHAR?

beginner
← All SQL Server questions
Re-explain

VARCHAR stores non-Unicode text in the code page of the column's collation, the character set that collation supports. NVARCHAR stores Unicode text, so it can hold any language.

  • VARCHAR(n): n is a size in bytes, up to 8,000. With a single-byte collation such as a non-UTF-8 Latin one, each character takes 1 byte. It suits text that fits one code page, such as English.
  • NVARCHAR(n): n is a size in byte-pairs, up to 4,000. Most characters take 2 bytes. Supplementary characters, those outside the basic Unicode range such as many emoji, take 4.

NVARCHAR needs more storage but supports international text. Unicode literals need the N prefix, as in N'Zürich', or they are converted to the database code page and can lose characters. From SQL Server 2019, a UTF-8 collation lets VARCHAR store Unicode too.

Rewriting in plainer words…

This answer doesn't lend itself to a diagram - it reads best . No credits were charged.

Why there's no diagram: “”

The interactive diagram is below the answer - jump to diagram ↓ · Below it, the related concept . Jump to it ↓

The diagram below the answer is the concept . Jump to it ↓

Tailored explanation · switch back to · ·
What should the new diagram focus on?
How well did you know this?
AI:

Saved in this browser - sign in to keep your review list.

How should your speech become text?

Listening… your words appear above as you speak - tap Stop when you're done.

Recording · cr - tap Stop & transcribe when you're done.

Transcribing with AI…

Voice:

Keep going - a few more words and AI can grade it.

Interview lens

Likely follow-ups, what you can say, and the weak answers to avoid.

Sign in free to open it Free account - the lens opens as soon as you're back.

Want a quick review of the fundamentals? See the SQL Server cheatsheet.

← Back to all SQL Server questions
Pro · $10/mo

42 of 47 SQL Server answers are in Pro.

Full answers, code samples, and AI explanations that go simpler or deeper. Cancel anytime.

  • Full answers + code
  • AI explanations, simpler or deeper
  • 1,000 AI credits / month
  • Cancel anytime