?
Solved

Special Character

Posted on 2014-11-24
4
Medium Priority
?
89 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

A new era in Cloud training has arrived.

A day that will go down in Cloud history.. But are you ready for it? Will you accept this Cloud challenge?

Question has a verified solution.

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

This article  is about submitting  form through  ColdFusion.Ajax.submitForm to the action page and send a response back in JSON format which later can be decoded using ColdFusion.JSON.decode. By this way you can avoid the usual page refresh for subm…
PROBLEM:  How to open a cfwindow or run a function on double click of a cfgrid row. One of my clients wanted to be able to double click on a row item to get more detailed information about a transaction and to be able to modify the line items i…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses

719 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