SQL Server 2000 - longer than nvarchar ????

• titifefe

  Grasshopper

  Points: 19

  More actions

  November 7, 2008 at 9:46 am

  #128513

  hi,

  is there any type longer than nvarchar for SQL Server 2000????

  nvarchar => 4000 bytes

  thanks

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 7, 2008 at 10:42 am

  #895706

  titifefe (11/7/2008)

  ---

  hi,

  is there any type longer than nvarchar for SQL Server 2000????

  nvarchar => 4000 bytes

  thanks

  In SQL Server 2000 (by the way, you posted this ina SQL Server 2005 forum) you can use ntext for columns that need more than 4000 characters.