I tried both of your suggestions to no avail.
On Thu, Jul 16, 2009 at 2:55 PM, Joe Pavao <jpavao@stripped> wrote:
> Troy,
> Try storing it as a blob. Use the urlencode() function in php
> before sending it to the db, and use the urldecode() function when
> grabbing it for disply.
>
> Joe
>
> -----Original Message-----
> From: Troy Oltmanns [mailto:toltmanns@stripped]
> Sent: Thursday, July 16, 2009 11:19 AM
> To: php@stripped
> Subject: Re: html input element rendering html entities
>
> Hey guys and gals,
>
> I have a little tricky situation so I will explain as best as I can.
>
> I've got a form that loads and saves product data to mysql. In some
> fields
> like the heading and subhead we use special characters like Omega,
> Registered Trademark, and Ampersand. When putting the data in I will
> encode
> them as Ω, etc. Once saved, all is good, everything goes ok and
> will
> display correctly in the user interface. However, if I go back to edit
> that
> product, in the html input element, it will actually display the
> character
> rather than the entity code (although when checking the source, the html
> entity is coded correctly). Then when it is saved, it saves as the
> illegal
> character and will serve up a few funky characters in the user interface
> and
> in the database.
>
> I have the code stripping out tags and I tried to use the
> mysql_real_escape_string to no avail.
>
> Anyone have experience with this kind of thing?
> PHP Version 5.1.6*MySQL 5.0.19*
>
> --
> MySQL PHP Mailing List
> For list archives: http://lists.mysql.com/php
> To unsubscribe: http://lists.mysql.com/php?unsub=1
>
>
