Results 1 to 4 of 4

Hybrid View

  1. #1
    Join Date
    Dec 2006
    Location
    Vermont
    Posts
    128
    Plugin Contributions
    0

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

  2. #2
    Join Date
    Dec 2006
    Location
    Vermont
    Posts
    128
    Plugin Contributions
    0

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

  3. #3
    Join Date
    Jun 2003
    Posts
    33,715
    Plugin Contributions
    0

    Default Re: Strange characters in descriptions suddenly

    Thanks for posting your solution.

    Might ask your host if they made any changes in the database server.
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

  4. #4
    Join Date
    Mar 2008
    Posts
    12
    Plugin Contributions
    0

    Default 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 View Post
    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.

 

 

Similar Threads

  1. v150 Strange characters appearing in product name/descriptions
    By kman55 in forum General Questions
    Replies: 2
    Last Post: 11 Jun 2012, 09:33 PM
  2. Number of characters of Short Descriptions addon
    By DML73 in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 9 Sep 2011, 04:48 AM
  3. product descriptions display funny characters
    By nysios in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 30 Aug 2008, 12:44 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR