Convert nText to varbinary

• SJanki

  SSCrazy

  Points: 2847

  More actions

  September 13, 2011 at 3:18 pm

  #247792

  Hi, I have PDF files stored as nText in SQL Server 2005,

  I have to transfer this data to SQL Server 2008 and have a reuquirement to display the PDF file from a web-application.

  I first did a cast from ntext to nvarchar(max), then from nvarchar(max) to varbinary(max) ,

  but when I try to display file using the .NET code, Acrobat gives error it is not a supported type file or has been damaged.

  Any idea how can I convert nText data to varbinary(max)

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  September 13, 2011 at 4:04 pm

  #1380957

  The following may give you some ideas:

  http://stackoverflow.com/questions/640862/change-column-type-from-ntext-to-varbinarymax

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/