soozh
asked on
nvarchar(99) v nvarchar(max)
Hello,
I have always designed tables using columns that are set to the size i needed.
However i have been told by a developer that we should just use nvarchar(max) to avoid any problems with column sizes in the future.
What is the thinking here. Is it a large overhead to use nvarchar(max) on everything?
/r
I have always designed tables using columns that are set to the size i needed.
However i have been told by a developer that we should just use nvarchar(max) to avoid any problems with column sizes in the future.
What is the thinking here. Is it a large overhead to use nvarchar(max) on everything?
/r
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The user now wants 100 chars because they have one email address that is 51 characters long.
The developer says use nvarchar(max) so we dont ever have this problem again.
But it seems to be using a sledgehammer to crack a walnut.