Special characters in name and address fields

My client is a worldwide organization of about 850 members and we are migrating to Joomla and Membership Pro. I have successfully imported all those members into Membership Pro. However, many of the non-US members have characters in their name and/or address that are displaying incorrectly with question marks. For example, part of one member's address in the CSV file is MERLO Nº5 in Valencia. Once imported it reads MERLO N?5. Is mysql making the substitution? Do you happen to have experienced this and needing to keep the original character?

Thanks in advance.

Hi

I don't think the problem is from Mysql. The problem might from the csv file itself. Maybe you should make sure you saved the data in CSV file in UTF-8 encoding before running the import ?

I am still on new year holiday at the moment, and will come back to office on Tuesday next week. So if you want, you can send me your CSV file on Tuesday and I will try to import it to see the result

Tuan

Please proceed with your holiday, Tuan. The problem was the ANSI encoding and when I saved the csv as UTF-8 the problem went away. Thanks very much!

Great. Thanks for the update. That's what I thought

Tuan

Hi again Tuan. I have solved my problem by importing csv UTF-8, but I notice that when I view the States you list in the Admin interface Membership Pro > States, I see question marks where special characters should be. For example, in Brazil, São Paulo displays as S?o Paulo.

That states database I downloaded from internet and to be honest, I didn't check them all. In this case, please edit these states directly from backend of Membership Pro to get it corrected

Regards,

Tuan