exporting text data type into csv file

• sql_fan

  SSC-Addicted

  Points: 462

  More actions

  February 1, 2006 at 11:40 am

  #111370

  I am exporting the data from a database table into a comma delimitted csv file. One of the column(notes) in the database table has a datatype text and when I export the data from this table only 256 characters are exported for the column notes. But my notes column has around 10000 characters.So how can I export all the characters into the csv file.

  Thanks.

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  February 1, 2006 at 12:20 pm

  #618202

  this may just be the 3rd post in as many weeks on this..

  text truncated at 256

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**