We help IT Professionals succeed at work.

When a field is declare with narchar(max), is this a wast or sapce?

750 Views
Last Modified: 2012-05-11
Should I specify a possible range that I know would satisfy for sure with like 100 char.  For instance, someone declare using max for a email field.  Does this waste the space or does it just make it flexible length?  Thanks.
Comment
Watch Question

Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2012
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Imran Javed ZiaConsultant Software Engineer - .NET Architect
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Good point, I don't know when I need unicode.  I just always use that .  I'll have to look that up.  You all got great input.  thank you.