Chinese characters displayed as ?????

If characters are returned as question marks ? it’s because the database table character set is not configured to support UTF8 characters and may be resolved by changing the character set for each table in your database to UTF-8.

You may reach out to your hosting provider to assist with this server-side task. It’s also good practice to create a full backup of your database before making any changes.

I hope this helps ??

Thanks Theus for your prompt response. I have access to the MySQL tables. There are 9 pmpro- tables in the DB. For each of them, I changed the character code to utf8mb4_unicode_520_ci from the dropdown list. It did not work. I also tried change it to utf8mb4_unicode_ci. No luck. I even restarted my ‘server’ and website. No help either. I have other plugins and they also use utf8mb4_unicode_520_ci for characters and I have no problem entering Chinese characters there. Not sure what else I can do.

Thanks for trying this @francoc30, would you mind trying to resave your level.

I tested Chinese characters and it works for “utf8mb4_unicode_ci” and it also worked for “utf8mb4_unicode_520_ci” on my test site. I set the encoding for the “name” for the membership level table.

Could you please share your level name with the Chinese characters so I may run some tests on my end to advise you further.

Hi Andrew, previously I set the encoding at the table level which didn’t work. You indicated to set it at the “name”. So I went into the table and set the encoding in each related columns of the Level table. It works. Thanks.
Can you tell me why the setting at the higher table level does not work and what is it suppose to do or function?

I’m glad to hear this resolved your issue. I’m not too sure why the table setting did not work, I think the column encoding may take priority over table encoding.