Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unicode Characters in Database

Status
Not open for further replies.

ljwilson

Programmer
May 1, 2008
65
US
I am having serious issues with several webpages. It seems to be happening when people copy and paste text from applications like MS Word.

I have written a function to replace some of these with the proper html characters (single quotes, double quotes, etc), but now more symbols are showing up in the DB.

Here is an example:
They unpack boxes, inspect items, and verify shipping documents, records all discrepancies, prices merchandise and posts orders on computer’s receiving vouchers.

That ’ probably should be translated as a single quote.

I have the following in the html for the pages that are doing this.
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[URL unfurl="true"]http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">[/URL]
<html>
<head>
<title>Change the Request</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
The funny thing is that I didn't start having these problems until I started making sure the pages were coded right. Before, some of them were missing the html and head sections and none of them had any sort of character set definition.

There must be some basic thing I am missing here. Any advice?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top