Geek Answers Handbook

Does nvarchar always take up twice as much space as varchar?

Nvarchar is used to store Unicode data, which is used to store multilingual data. If you do not finish saving Unicode, will it still occupy the same space?

+6
sql database
source share
2 answers

YES.

See the MSDN Internet Books on NCHAR and NVARCHAR .

NCHAR:

Storage size two times n bytes.

NVARCHAR

The storage size in bytes is two characters entered + 2 bytes

+6
source share

Grade. Not all Unicode characters use two bytes. For example, Utf-8 still remains one byte for each character, but rarely you may need 4 bytes per character. What nvarchar will do is allocate two bytes per character.

+1
source share

More articles:


All Articles