char vs. nvarchar
Posted on 2004-09-28
I understand the difference between char and nvarchar...basically the length.
char: Fixed-length non-Unicode character values with a maximum length of 8000 characters
nvarchar: Variable-length Unicode data wtih a maximum length of 4000 characters.
But, the problem is, most books don't give you a real world example of typical fields such as
City....and so on
I have always used nvarchar for things like address, city, state, etc. because they don't require a long data type because of performance issues.
However this is what i don't know:
1) What is Fixed-length
2) What is non-Unicode vs. Unicode
3) Why is it standard to create a phone field as nvarchar instead of an int
things like this. Can someone answer my 3 questions here.