Strange characters in descriptions suddenly
Hi,
I suddenly noticed that there are strange characters in many of my item description fields.
I'm wondering if someone can tell me a SQL command that I can use to replace them all with blank spaces.
The character is a capital "A" with a carat over it, like this (if it shows right): Â
Sometimes in bold as: Â
I would greatly appreciate if someone can help me get rid of these programatically, without having to manually edit ALL my items.
Thanks.
Re: Strange characters in descriptions suddenly
Never Mind... I found the solution:
UPDATE products_description SET products_description = REPLACE(products_description, 'Â', '')
(I actually needed to replace it with NOTHING, not a blank space, but didn't realize it until I took a closer look)
Thanks.
Re: Strange characters in descriptions suddenly
Thanks for posting your solution.
Might ask your host if they made any changes in the database server.
Re: Strange characters in descriptions suddenly
I have been having the same problem but it also occurs on information pages too such as Terms and Conditions.
I thought it was because I used a non-standard font but I have since switched back to Times New Roman and it still happens randomly, not necessarily to the pages which are being edited either.
website: petersphotography.co.uk
zc version 1.3.8a
lots of customisation!
Quote:
Originally Posted by
rcrosier
Hi,
I suddenly noticed that there are strange characters in many of my item description fields.
I'm wondering if someone can tell me a SQL command that I can use to replace them all with blank spaces.
The character is a capital "A" with a carat over it, like this (if it shows right): Â
Sometimes in bold as: Â
I would greatly appreciate if someone can help me get rid of these programatically, without having to manually edit ALL my items.
Thanks.