Storage Difference between varchar and nvarchar

I have a table with two fields. Both are nvarchar in type. I have 100,000 records in this table.
I have stored normal characters only in those fields, it doesn't have any international characters. If i change the datatype from nvarchar to varchar, Will the storage size of that table decreases?

ynainaAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
Differences are
1. Nvarchar can store non unicode characters such as Arabic, Hindi etc, but varchar can't
2. nvarchar needs double the storage space needed for a varchar

> If i change the datatype from nvarchar to varchar, Will the storage size of that table decreases
If the field was previously say nvarchar(4000) and you changed it to varchar(4000),then it will need half space for storage

0
 
illCommented:
sizeOf( varchar)= 0.5* sizeOf ( nvarchar)
0
 
ynainaAuthor Commented:
any data loss can happen in this process
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
If you dont have unicode characters , nothing will loss
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.