Home Forums Article Discussions Article Discussions by Author Discuss content posted by Carlo Romagnano CASTing RE: CASTing

  • May 29, 2008 at 8:36 am

    #821793

    Does that mean this 2 lines below, converts @C to nvarchar(8000)?

    meaning ANY casting to nvarchar always give it maximum length of 8000?

    declare @C varchar(800)

    set @C = N'hello'

    I think I got lost by reading this sentence ... maybe I shouldn't read it anymore

    The CAST to nvarchar(800) has a maximum 4000 character len.

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005