Solved

Special Character

Posted on 2014-11-24
4
87 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

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

PROBLEM: How to add your own buttons to the bottom toolbar with paging info ( result count ). While creating a cfgrid, I ran into an issue where I wanted to embed my own custom buttons where the default ones ( insert / delete / etc… ) are for aes…
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 …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

710 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