Smart quotes, special charaters and apostrophe display on web

We are having a problem with displaying smart quotes and apostrophes on the web particularly those coming from a database using SQL and coldfusion. Smart quotes are displaying as ý
Apostrophes are displaying as ?
I have tried <meta http-equiv="content-type" content="text/html; charset=utf-8" />
and <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
but neither of these seems to work.
Does anyone have any ideas about how to get these to display correctly.

cbeverlyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
gdemariaConnect With a Mentor Commented:

You can replace them with their non-microsoft equivalent..

Assuming your variable is called "myString"..
This will replace a handful of MS special characters..

<cfscript>
 myString = Replace(myString, chr(8217), chr(39),"ALL");
 myString = Replace(myString, chr(8216), chr(39),"ALL");
 myString = Replace(myString, chr(8220), chr(34),"ALL");
 myString = Replace(myString, chr(8221), chr(34),"ALL");
 myString = Replace(myString, chr(8211), "-","ALL");
</cfscript>

0
 
R7AFCommented:
This is typically a character encoding problem. Can you tell us what the character encoding is you're using. I've had this situation when the character encoding of a page was UTF-8, data from SQL Server. When using character encoding ISO-8859-1 the problem was gone.

http://htmlhelp.com/tools/validator/charset.html.en
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">

Open in new window

0
 
cbeverlyAuthor Commented:
Below is the code snippet I'm using. The first part is the actual code including quotes etc. And following is what actually displays.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
</head>
 
 
<body>
“Uncle Jack” Day created this brightly colored scene to show the moment when Adam and Eve were cast out from paradise. An angel flies down to greet the couple with an “eviction notice,” while their bleak future is spelled out in a note on the ground: “Gravy train gone. Adam settled down. Work hard in the barren land . . .” Dey copied the figures from a reproduction of Michelangelo’s Sistine Chapel ceiling, but instead of showing a large, threatening snake as their tempter, he painted a small creature that hides in the grass. (Lynda Hartigan, Made with Passion, 1990) The artist filled the painting with stripes and dabs of pure color to evoke Eden’s lush surroundings.
 
 
</body>
</html>
 
 
This displays as
�Uncle Jack� Day created this brightly colored scene to show the moment when Adam and Eve were cast out from paradise. An angel flies down to greet the couple with an �eviction notice,� while their bleak future is spelled out in a note on the ground: �Gravy train gone. Adam settled down. Work hard in the barren land . . .� Dey copied the figures from a reproduction of Michelangelo�s Sistine Chapel ceiling, but instead of showing a large, threatening snake as their tempter, he painted a small creature that hides in the grass. (Lynda Hartigan, Made with Passion, 1990) The artist filled the painting with stripes and dabs of pure color to evoke Eden�s lush surrounding

Open in new window

0
 
cbeverlyAuthor Commented:
When I cut and pasted this code there were quotes in the code part but now when I view it, it is inserting strange characters in the code as well as the display
0
 
TenTonJimCommented:
Make sure your text editor is set to UTF-8 also.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.