Hi DBAs and others,
I'm redesigning a table that has many nvarchar columns... I think someone just left them as nvarchar because that's what they were after upsizing an Access database.
Does a nvarchar (60) col actually use 120 characters for storage?
Have you found any differences in performance between varchar vs. nvarchar?
Which data type do you normally use?
We are a US company.
Thanks for any advice. John
I'm redesigning a table that has many nvarchar columns... I think someone just left them as nvarchar because that's what they were after upsizing an Access database.
Does a nvarchar (60) col actually use 120 characters for storage?
Have you found any differences in performance between varchar vs. nvarchar?
Which data type do you normally use?
We are a US company.
Thanks for any advice. John