SQL Server Performance

length of NVARCHAR data type shows double

Discussion in 'General DBA Questions' started by nazri, May 17, 2007.

  1. nazri New Member

    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



  2. satya Moderator

    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.
  3. FrankKalis Moderator

    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

Share This Page