special character??? How do I handle it??

[qajussi]

Hi!

How do I handle the special characters?
I have a database which was populated by copying the data from the internet web pages.
So some of the text contains different kinds of special characters.
For instances, I have single two different quotes
1) ‘Geroge Bush’ <== this one is fine for web pages
2) 'Bill Gate' <= not this one.

Do you know why #1 was ok but not #2??
(I am using vbscripting to extract from the database and displaying them in html pages)

My data contains tons of single quotes like that
I want to do "find & replace".
What is the iso code for #1 and #2??
Thank you very much.

 

[cLFlaVA]

you would do this in vb, not in HTML, XHTML, nor CSS.

*cLFlaVA
----------------------------
[tt]a frickin' twelve-gauge, what do you think?[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[mkrausnick]

Left single quote: &lsquo;
Right single quote: &rsquo;
Apostrophe: &apos; but this is not widely supported.

A very complete list of codes can be found at:

http://www.w3schools.com/html/html_entitiesref.asp

Mike Krausnick
Dublin, California

 

[Foamcow]

Google is your friend

http://www.htmlhelp.com/reference/html40/entities/

Foamcow Heavy Industries - Web design and ranting
Toccoa Games - Day of Defeat gaming community
Target Marketing Communications - Advertising, Direct Marketing and Public Relations
"I'm making time