Home > Archive > MS SQL Server > May 2005 > Q: 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 Q: nvarchar text fields
JIM.H.

2005-05-31, 8:23 pm

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





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com