Solved

Special Character

Posted on 2014-11-24
4
84 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

I spent nearly three days trying to figure out how incorporate OAuth in Coldfusion for the Eventful API. Hopefully, this article will allow Coldfusion Programmers to buzz through the API when they need to. Basically, what this script does is authori…
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

828 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