Monday, February 26, 2007

NVARCHAR vs. VARCHAR

I always wondered what the difference was:

NVARCHAR is used to hold unicode characters used to hold multilingual data. It also takes up twice as much space to hold 1 character as it's VARCHAR counterpart, due to the need for those extra bits.

So for the most part...unless you've got a db in multiple languages, USE VARCHAR!

No comments: