Quote Originally Posted by Jatty View Post
Question, all my copyright and single quote characters get converted to the "?" in the black diamond symbol. I have tried every setting in the configuration and nothing works to correct this.

I am running EP 4.22... What to do now?
This is a character encoding issue. You likely loaded your data from a iso-8859-1 source, but failed to let Open Office know before exporting and selecting UTF-8. This is hard to fix once it's messed up.

At this point you're better off doing a search and replace in your data. Also, depending of the source encoding, some single quote representations can potentially break EP4's import. Char(092) is a funky one.

Also, converting "smart" quotes between character encoding can also cause problems. Open Office CAN do it correctly for you, but you must let it know the source data's encoding when you first open the csv.

Excel will not give you this option and will totally FUBAR you data ...

-chadd