{"id":1304,"date":"2014-02-17T10:03:29","date_gmt":"2014-02-17T09:03:29","guid":{"rendered":"http:\/\/blog.kodono.info\/wordpress\/?p=1304"},"modified":"2014-02-17T11:04:38","modified_gmt":"2014-02-17T10:04:38","slug":"requete-mysql-insensible-aux-accents","status":"publish","type":"post","link":"https:\/\/blog.kodono.info\/wordpress\/2014\/02\/17\/requete-mysql-insensible-aux-accents\/","title":{"rendered":"Requ\u00eate MySQL insensible aux accents"},"content":{"rendered":"<p>Pour effectuer une requ\u00eate MySQL qui ne sera pas sensible aux accents (par exemple &#8216;\u00f6&#8217; = &#8216;o&#8217; ou &#8216;\u00e0&#8217; = &#8216;a&#8217;) il faut rajouter le mot cl\u00e9 COLLATE avec la bonne collection. Apr\u00e8s plusieurs tests, j&#8217;utilise la collection <strong>utf8_general_ci<\/strong>.<br \/>\nCe qui donnera :<\/p>\n<pre class=\"brush:sql\">SELECT ID, Nom FROM Inscrits WHERE Nom LIKE '%heracles%' COLLATE utf8_general_ci ORDER BY Nom<\/pre>\n<p>Qui retournera, par exemple, &#8220;H\u00e9racl\u00e8s&#8221;.<\/p>\n<p>ATTENTION : si cette requ\u00eate fonctionne sur le serveur directement, mais pas dans votre code PHP, alors il faudra peut-\u00eatre utiliser <code>mysqli_set_charset('utf8');<\/code> dans votre code afin que la liaison se fasse correctement.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pour effectuer une requ\u00eate MySQL qui ne sera pas sensible aux accents (par exemple &#8216;\u00f6&#8217; = &#8216;o&#8217; ou &#8216;\u00e0&#8217; = &#8216;a&#8217;) il faut rajouter le mot cl\u00e9 COLLATE avec la bonne collection. Apr\u00e8s plusieurs tests, j&#8217;utilise la collection utf8_general_ci. Ce qui donnera : SELECT ID, Nom FROM Inscrits WHERE Nom LIKE &#8216;%heracles%&#8217; COLLATE utf8_general_ci ORDER [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","hide_page_title":"","footnotes":""},"categories":[11,33],"tags":[63,151,158],"class_list":["post-1304","post","type-post","status-publish","format-standard","hentry","category-niveau-debutant","category-programmation","tag-mysql","tag-niveau-debutant","tag-programmation"],"_links":{"self":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts\/1304","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/comments?post=1304"}],"version-history":[{"count":4,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts\/1304\/revisions"}],"predecessor-version":[{"id":1306,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts\/1304\/revisions\/1306"}],"wp:attachment":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/media?parent=1304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/categories?post=1304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/tags?post=1304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}