UTF-8 language import locale string problem! Nop 4.3 & MySQl

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
3 anos atrás
Problem when I import Vietnamese  language w/ utf-8 character. I just found out that some character import from xml file is being replaced by '?' character. I'm using nop 4.3 & mysql DB. How can i fix it. I just google and think that the problem orcus when fluent migrator transalte to SQL command and Mysql does not support Nvarchar type.
How can i fix this issue?
Many Thanks nop team.

https://imgur.com/CkVzpmw
https://imgur.com/wj5pUW3
https://imgur.com/k0AW2bU





2 anos atrás
It's been a while, but I hope it helps.
I had a similar situation and fixed it as below.

Just try to change mysql collation to utf8_general_ci and mysql charset to utf8.

For new installation or you can delete appsettings.json to reinstall from scratch.:
・Set the connect string (connection string textbox on install page) as bellow
"server=<server>;port=<port>;database=<db>;uid=<uid>;pwd=<password>;charset=utf8;"
・Set mysql collation (collation textbox on install page):utf8_general_ci
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.