MS SQL Server - Re: nvarchar text fields

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: nvarchar text fields

Robbe Morris [C# MVP]

2005-05-31, 8:23 pm

It is true. No, this is not a problem. However, make
common sense decisions. If you really don't need
255 characters for something like a postal code or
person's first name, then set it accordingly.

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net

"JIM.H." <JIMH@discussions.microsoft.com> wrote in message
news:4C8A64C9-825C-41FC-BFF3- 3E4855F3AFB0@microso
ft.com...
> Hello,
> I heard if I define a field nvarchar(255), SQL Server optimize this and
> reserve only the amount of the characters entered. If that is true, do you
> see any problem if I set nvarchar(255) for all my text fields in the
> database
> to avoid any future problems regarding requiring more character space.
> Thanks,
> Jim.
>

Sponsored Links