by the way, you probably don't want to do the conversion *inbound* to
the database. rather, store the original and do the conversion outbound
- specific and appropriate for the output display.
if you do it inbound you'll have the html encodings (rather than the
actual ("special") characters) stored in your database. then, if you
have need to do output as say plain text (as opposed to html) you'll
have to unconvert the encodings.
Totally understand this and agree with you 100% However,
what you may want to do inbound is to convert os/application-specific
characters, e.g., smart quotes, to more standard representations.
wouldn't this be a headache? Considering I don't know what OS my users are going to be using?
Ack! I hate dilemmas. :)
Thanks for the reply!
------------ Original Message ------------
Date: Monday, August 22, 2005 08:42:14 AM -0500
From: Jay Blanchard <jay.blanchard@niicommunications.com>
To: Jay Paulson <jpaulson@sedl.org>, php-general@lists.php.net
Subject: RE: [PHP] Special HTML characters question.
[snip]
I have a problem that I'm sure some of you have run into before,
therefore I hope you all know of an easy solution. Some of my users
are cutting and pasting text from Word into text fields that are being
saved into a database then from that database being displayed on a web
page. The problem occurs when some special characters are being used.
Double quotes, single quotes, and other characters like accents etc
have the special html code like "e; etc replacing the special
characters. What methods are being used to combat this issue? Is
there a solution out there to run text through some sort of filter
before submitting it to the database to look for these special
characters and then replacing them?
[/snip]
Start here http://www.php.net/htmlentities . You can also use any
number of REGEX functions for replacing them http://www.php.net/regex
-- PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php