Link to home
Start Free TrialLog in
Avatar of lulu50
lulu50Flag for United States of America

asked on

Special Character

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
Avatar of FarWest
FarWest

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
ASKER CERTIFIED SOLUTION
Avatar of lulu50
lulu50
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of lulu50

ASKER

Thanks