tn_bobbie
asked on
CSV files export with Classic ASP, special chars
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.. & attached CSV files
The lines in the code are the options I tried.
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 1500 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
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.. & attached CSV files
The lines in the code are the options I tried.
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 1500 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
' 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
i dont understand the request, you mean you need a code to generate csv files?
ASKER
Hi,
I have all the working code for generating the CSV files. All is good till I export plain English chars. The problem occurs when I have special chars (non-english chars) in the exported csv files.
The non-english chars look good when the exported file size is small (may be 15 records in the exported csv file). But when the file size grows (may be 1000 records in the exported csv file), the non-english chars get garbled.
Look at the code I have to export the csv files.
Thanks
Bobbie
I have all the working code for generating the CSV files. All is good till I export plain English chars. The problem occurs when I have special chars (non-english chars) in the exported csv files.
The non-english chars look good when the exported file size is small (may be 15 records in the exported csv file). But when the file size grows (may be 1000 records in the exported csv file), the non-english chars get garbled.
Look at the code I have to export the csv files.
Thanks
Bobbie
ASKER
What happened to the Experts Exchange? No posts for the past 2 days??? This is very stunning & this is the first time I'm seeing this in EE. If EE can't help me, who else can.
Some one plz help me..
Bobbie
Some one plz help me..
Bobbie
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Bobbie