3

Whenever I export a csv from any report, if it contains a £ sign, there is always  appears before. How to resolve it please? I am using civicrm 4.6.11, my mysql database characterset is set to "UTF8".

2

My workaround for this is to immediately convert the CSV file in a text editor such as Notepad++ or UltraEdit.

As soon as it's downloaded I open the CSV as UTF8, then immediately save it as ANSI. It's a bit fiddly, but fixes the £ problem, as well as any unusual characters in names/addresses.

| improve this answer | |
1

When you look at the csv, what software do you use? Are you looking with Excel, and if so is Excel also expecting UTF8?

| improve this answer | |
  • yes, I am using Excel 2013. I didn't understand, what do you mean by " is Excel also expecting UTF8?" – Tapash Jan 11 '16 at 9:20
  • Excel also uses encoding to show you the csv file. If Excel is set to a different encoding you will get strange characters. See help.surveygizmo.com/help/article/link/… – ErikH - CiviCooP Jan 11 '16 at 11:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.