Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Posts
    627
    Plugin Contributions
    0

    Default An invalid character in descriptions - sql query to remove?

    I've come across a zen cart (1.3.9h) that is having a problem getting the rss feed to display. The problem is due to invalid characters in many of the descriptions showing up as this �. When viewing the descriptions in admin you can not see anything but a space where the invalid character occupies in the description on the front end. The site owner is not sure how they got there but it is possible the descriptions were typed in microsoft word, copied and pasted into zen cart.

    There are sooo many descriptions to be fixed. My question. Is there an sql query that can be run in the database to remove the invalid characters from the description table?

  2. #2
    Join Date
    Feb 2007
    Posts
    327
    Plugin Contributions
    0

    Default Re: An invalid character in descriptions - sql query to remove?

    I am getting the same character � when i copy and paste product description from my vendor, i did not have that problem with zen 1.3.7 .

    problem on zen 1.3.9h.

    Could it be a collation problem?

 

 

Similar Threads

  1. Replies: 9
    Last Post: 12 Jul 2023, 12:26 AM
  2. v154 Help with a SQL Query for Query Builder
    By lindasdd in forum Managing Customers and Orders
    Replies: 2
    Last Post: 24 Mar 2016, 01:18 PM
  3. v151 SQL query setup. How do I TEST a query 'off-line'?
    By lewisasding in forum General Questions
    Replies: 3
    Last Post: 8 Mar 2013, 12:24 AM
  4. Query sql needed to remove customers that aint ordered
    By Xbox Memberships in forum General Questions
    Replies: 0
    Last Post: 2 Apr 2010, 04:18 PM

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