Hi, Why the length of NVARCHAR data type shows double when using sp_help??? example.. sp_help abc col_name type length ........ Name nvarchar 100 ...... while the actual length is 50
Use DBCC UPDATEUSAGE and then see the results. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
To support Unicode characters you need 2 bytes instead of 1. That's the drawback when using N(VAR)CHAR. -- Frank Kalis Moderator Microsoft SQL Server MVP Webmaster:http://www.insidesql.de
