Help. Smart quotes and apostrophes in CSV export file are causing weird â€™ characters
I'm exporting a "product feed" from our FMP database. We export as CSV and then upload that CSV file to "FeedPerfect" and then FeedPerfect sends it out to 4 or 5 shopping comparison sites (including goggle base).
I've tried every type of encoding in our CSV file. I've tried Mac, UTF-8, UTF-16, ASCII and most of the others. I've tried opening the CSV file in bbedit and use their "straighten quotes" to remove any smart quotes. Nothing works. The uploaded file always ends up encoding problems which cause apostrophes turned into "â€™" and other issues.
What else can be done to fix this problem?