CSV Export not exporting accented characters right

In Membership Pro the Export to CSV does not export accented characters properly. The characters show up correctly in email and also in the Joomla Administrator. Only place where they show up as garbage is n the csv file. I believe maybe because it's being exported as ASCII instead of UTF-8.

Can this be fixed?

Just to add a comment related to the above, accented characters do NOT show up correctly for me in administrator (e.g. setup -> States), they appear as question marks. I have not tested the extension in live mode yet but i assume that customer names with accented characters will also appear as question marks or similar, which is a huge problem when it comes to finding/editing user details whenever needed. Please make sure the extension is updated to use UTF-8 in every part, this is very important, especially for a membership extension.

@Rafal: Could you please try to open the csv file in a text editor, then try to save it to UTF - 8 ? If you use notepad++, you can use the function Convert To Utf-8 without BOM in notepad++ to convert the encoding and it should work well

The other way is upload the file to Google Doc, then save it back to your computer (I know it is not a normal way) so that Google will convert the font for us automatically

@ensigcom: For states name, I think there are some states name wrong in the database. You can go to Events Booking -> States, edit these states and the name should be saved properly

There are some problem when exporting to csv file and to be honest, we don't have a good solution yet. But the data is saved to database properly and we should not have any problem with it

Tuan