{"id":473,"date":"2023-10-23T20:21:30","date_gmt":"2023-10-23T20:21:30","guid":{"rendered":"https:\/\/sites.bc.edu\/sonn\/?p=473"},"modified":"2023-10-23T20:21:31","modified_gmt":"2023-10-23T20:21:31","slug":"php-mysql-european-language-diacritical-marks","status":"publish","type":"post","link":"https:\/\/sites.bc.edu\/sonn\/2023\/10\/23\/php-mysql-european-language-diacritical-marks\/","title":{"rendered":"PHP mySQL &#8211; European Language diacritical marks"},"content":{"rendered":"\n<p>3 places to handle diacritical marks in a Eurpoean web applications<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Set mySQL database Collation to latin1_swedish_ci <\/li>\n\n\n\n<li>Set mySQL column Collation to utf8_unicode_ci <\/li>\n\n\n\n<li>In PHP HTML <br>&lt;meta http-equiv=&#8221;Content_Type&#8221; content=&#8221;text\/html; charset=UTF-8&#8243;\/><\/li>\n\n\n\n<li>In PHP script set mysqli charset<br>mysqli_set_charset($conn,&#8221;utf8&#8243;);<br>$rs = mysqli_query($conn,$sql);<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<div class=\"entry-summary\">\n3 places to handle diacritical marks in a Eurpoean web applications\n<\/div>\n<div class=\"link-more\"><a href=\"https:\/\/sites.bc.edu\/sonn\/2023\/10\/23\/php-mysql-european-language-diacritical-marks\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &ldquo;PHP mySQL &#8211; European Language diacritical marks&rdquo;<\/span>&hellip;<\/a><\/div>\n","protected":false},"author":131979,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-473","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"_links":{"self":[{"href":"https:\/\/sites.bc.edu\/sonn\/wp-json\/wp\/v2\/posts\/473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.bc.edu\/sonn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sites.bc.edu\/sonn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sites.bc.edu\/sonn\/wp-json\/wp\/v2\/users\/131979"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.bc.edu\/sonn\/wp-json\/wp\/v2\/comments?post=473"}],"version-history":[{"count":1,"href":"https:\/\/sites.bc.edu\/sonn\/wp-json\/wp\/v2\/posts\/473\/revisions"}],"predecessor-version":[{"id":474,"href":"https:\/\/sites.bc.edu\/sonn\/wp-json\/wp\/v2\/posts\/473\/revisions\/474"}],"wp:attachment":[{"href":"https:\/\/sites.bc.edu\/sonn\/wp-json\/wp\/v2\/media?parent=473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.bc.edu\/sonn\/wp-json\/wp\/v2\/categories?post=473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.bc.edu\/sonn\/wp-json\/wp\/v2\/tags?post=473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}