This is because when the query is sent to MySQL, it’s encoded using the default charset, which is usually set to latin.<\/p>\n\n\n\n
For some reason, it’s not a problem in Windows.<\/p>\n\n\n\n
For PHP, when creating a connection to MySQL, call set_charset to set the character set to UTF8.<\/p>\n\n\n\n
For ASP.NET Core application, set the charset in the connection string: CharSet=utf8.<\/p>\n","protected":false},"excerpt":{"rendered":"
This is because when the query is sent to MySQL, it’s encoded using the default charset, which is usually set to latin. For some reason, it’s not a problem in Windows. For PHP, when creating a connection to MySQL, call set_charset to set the character set to UTF8. For ASP.NET Core application, set the charset … Continue reading “Non-English characters become question marks when inserting into MySQL server in Ubuntu Linux server”<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[2,106,111],"class_list":["post-759","post","type-post","status-publish","format-standard","hentry","category-problems","tag-asp-net","tag-mysql","tag-php"],"_links":{"self":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts\/759","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=759"}],"version-history":[{"count":1,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts\/759\/revisions"}],"predecessor-version":[{"id":760,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts\/759\/revisions\/760"}],"wp:attachment":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}