.csv import creating black diamond with a question mark

Question

A .csv import is creatinga the black diamond with a question mark in place of the apostrophe & quotation marks.  I'm importing text into the Description field and a multi-text field. Looking at the .csv file, it seems these text blocks are not being surounded by quotes as I believed they would.

I am not going to search and every single quote ( ' ) with ( " ' " ).

Any ideas?

Jim

Pete Singleton · Accepted Answer

The black question mark is when a character is unrecognised.  You need to select the right encoding before import.  I usually do the following before importing CSV:

* Edit the file in Excel or whatever you are using
* Save as CSV (not Windows CSV, the standard CSV)
* Open in notepad
* Select "Save As..." and make sure you choose encoding of UTF-8 instead of ANSI
* Make sure UTF-8 is selected as the encoding when you import