ynaina
asked on
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?
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?
sizeOf( varchar)= 0.5* sizeOf ( nvarchar)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
any data loss can happen in this process
If you dont have unicode characters , nothing will loss