That's the thing, it is being saved the same way, it's that when the page
loads the data the input element automatically changes the display to the
special character, and when it saves, it saves as that character.

On Thu, Jul 16, 2009 at 2:37 PM, Govinda <>wrote:

> 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 &Omega;, 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
> I am newbie here, but isn't it that you just need to save at this ^^ point
> the same way that you saved the data in the first place?
> If it worked the first time, why not now?
>  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*
> ------------
> Govinda
> --
> PHP Database Mailing List (
> To unsubscribe, visit:

Reply via email to