DataType issue

• balaji.ganga 68339

  Right there with Babe

  Points: 755

  More actions

  February 3, 2012 at 12:24 am

  #252303

  Hi,

  I have created the below table

  create table sample(id int,textdata varchar(max))

  It contains huge amount of data. I'm trying to export this table from sqlserver 2008 to sqlserver 2000. But it shows an warning threshold while exporting the entire textdata. Because it is automatically converted from varchar(max) to varchar.

  Varchar will allow only 8000 char only. In our textdata column having more than 15000 characters.

  I would appreciate, If anybody help me, to resolve this issue.

  Thanks in advance

  Regards

  Balaji G

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  February 3, 2012 at 12:55 am

  #1442227

  Varchar(max) was introduced in SQL2005.

  In SQL 2000 you had to use the text datatype if you want to store more than 8000 characters.

  [font="Verdana"]Markus Bohse[/font]