Strange characters in descriptions suddenly

[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.

[rcrosier]

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.

[Kim]

Thanks for posting your solution.

Might ask your host if they made any changes in the database server.

[gaynorti]

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!

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.