Weird Characters - Need an SQL solution!

[RodG]

MY QUESTION:
Is there a way to automate the UPDATE process with an SQL command I can just drop in the SQL Query Executor?

It would take me all day to go thru Admin, click on each product and hit Preview, then Update.

Any help would be greatly appreciated!
~Mike

Sorry Mike, but the answer is no.

lhungil said pretty much the same thing, possibly without realising it.

This is what I think is happening:

CKEditor and similiar tools have added detection to "replace" these characters. When you open the product / catalog page using the admin interface the characters were probably replaced with html entities, encoded the character for your charset, or replaced with a plain ".

In other words, it is the CKeditor that is doing the actual 'fixing', therefore MySQL and its 'update' command can't be of much help in this regard.

I've no doubt that there is a way to do this entirely with SQL (leaving CKeditor out of the picture) but it would probably be best/easiest to fix the data via other means (such as exporting to CSV, doing a search replace, then re-importing).

Cheers
Rod