Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Special Character

Posted on 2014-11-24
4
Medium Priority
?
93 Views
Last Modified: 2014-11-29
Hi,

I have a button on a page that generate an excel file report.  

on that excel file report, it's printing the special character like this.
 

  Virtual ID Card – Customer Specific Customer Service Information  

Open in new window


It is stored in the database like this:

Virtual ID Card – Customer Specific Customer Service Information

Open in new window



I'm not sure what cause this or how to solve it.

I need your help please.

<cfheader name="Content-Disposition" value="inline; filename=SJFReport.xls"  >
<cfcontent type="application/msexcel">

Open in new window


Thanks,
Lulu
0
Comment
Question by:lulu50
  • 2
  • 2
4 Comments
 
LVL 12

Expert Comment

by:FarWest
ID: 40462222
try to delete and re-write the problematic part of the  string in the Database , (without using cut/paste)
if it did not work , check if code page or collation on the database server
0
 

Accepted Solution

by:
lulu50 earned 0 total points
ID: 40462262
I fixed the issue:

I added this to my code and it works fine:

<cfcontent type="application/vnd.ms-excel; charset=windows-1252">

Open in new window

0
 
LVL 12

Expert Comment

by:FarWest
ID: 40462279
good job,

although the "-" is a Latin character that must not be effected with code page,

that means your "-" was typed while keyboard was changed to none-English language
0
 

Author Closing Comment

by:lulu50
ID: 40471418
Thanks
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, Even though I have created this Tutorial on My personal Blog, Some people might not able to find my website, So here i am posting it again Today, from the topic it is very clear that i will be showing you here the very basic usage of how we …
Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them (http://www.randhawaworld.com/) . I did keep the main js functions but made sever…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question