Link to home
Start Free TrialLog in
Avatar of lapucca
lapucca

asked on

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

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.
ASKER CERTIFIED SOLUTION
Avatar of hongjun
hongjun
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lapucca
lapucca

ASKER

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.