Community discussion forum

CSV files export with Classic ASP, special chars

• • Reply

  5 months ago

  by Sud_84

  Sudhir Kumar S

  , Australia

  Joined 8 months ago

  HI All
  
  I'm exporting data from Oracle DB to CSV files using Classic ASP. All is good here except some issues with special chars. The Special chars get garbled when the file size is increasing.
  
  Look at my code..
  
  The lines in the code are the options I tried.
  
  Here is the code
  
  ' Create the CSV file
  Response.Clear
  Response.ContentType = "text/plain;charset=utf-8;"
  'Response.AddHeader "Content-Type", "text/csv;charset=UTF-8"
  Response.AddHeader "Content-Disposition", "attachment;filename=Data.csv"
  'Response.CharSet = "utf-8"
  
  ' Writing data
  Response.write data
  
  The special chars in this row is part of the CSV file
  
  "testing special chars dès 196 vol+ hôtel"
  
  is completely getting junk when the file size is big (may be 1000 records). But when the file size is small (may be 20 records) it is perfectly good.
  
  BAsed on some parameters (user selection) in the webpage & clicking on the submit button, I'm calling an ASP file that creates the CSV file.
  
  
  
  Plz help me. I badly need this..
  Thanks
  Bobbie
  

  Report abuse