I was able to succesfully import 9400 products into my Zen database, however I have run into one small issue. It's an annoyance more than anything, but for many many products, the quotes and single quotes are being replaced by â€, little little white squares, etc. Prior to insertion, I removed all of the special characters that would give the tables problems, like the TM marks, etc. I didnt figure apostrophe's and quotation marks would be an issue.
Anywhoo... after searching, I found a post in the archives, a hint at a script that would removed bad characters and replace them with good characters. However the link in the article was bad, and I am unfortunately not at the level to understand what the script was doing.
For example.
I know that everywhere I see †its a " (however in some places, "'s show up fine)
’ is a '
Is there some sort of script I can run, or an SQL command that will run through the product description table and find/replace these characters?
Bookmarks