{"id":466,"date":"2017-08-27T01:02:44","date_gmt":"2017-08-27T01:02:44","guid":{"rendered":"http:\/\/www.gnial.com.br\/gnialhelp\/?p=466"},"modified":"2019-11-26T10:31:33","modified_gmt":"2019-11-26T13:31:33","slug":"parte-2-de-2-mysql-php-iso-utf8-utf8_general_ci-utf8_unicode_ci","status":"publish","type":"post","link":"http:\/\/www.gnial.com.br\/gnialhelp\/parte-2-de-2-mysql-php-iso-utf8-utf8_general_ci-utf8_unicode_ci\/","title":{"rendered":"Parte 2 de 2 – MYSQL, PHP, ISO, utf8, utf8_general_ci, utf8_unicode_ci"},"content":{"rendered":"

Artigo 1<\/a><\/p>\n

Artigo 2<\/p>\n

Usando PHP<\/h2>\n

Caso precise codificar e descodificar, \u00e9 nesta ordem:<\/p>\n

utf8_encode() > html_entity_decode() > htmlentities() e em \u00faltimo caso, se nada disso funcionar, use o header(‘content-type text\/html charset=utf-8’);<\/p>\n

Usando META TAGS<\/h2>\n

<meta charset=”utf-8″>
\n<meta http-equiv=”Content-Type” content=”text\/html; charset=UTF-8″ ><\/p>\n

Conex\u00e3o PDO<\/h2>\n

MySQL (PDO):
\n$dsn = “mysql:host=localhost;dbname=world;charset=utf8”;<\/p>\n

MySQL<\/h2>\n

MySQL:
\nCREATE DATABASE nome_bd CHARACTER SET UTF8;<\/p>\n

COLLATE
\nIn short: utf8_unicode_ci<\/strong> uses the Unicode Collation Algorithm as defined in the Unicode standards, whereas utf8_general_ci is a more simple sort order which results in “less accurate<\/strong>“[preciso] sorting results. But faster<\/p>\n

Explicacao de unicode and general<\/strong>
\nutf8_general_ci
\nutf8_unicode_ci
\nhttps:\/\/pt.stackoverflow.com\/questions\/43281\/qual-collate-utf-8-%C3%A9-o-mais-apropriada-para-web-multi-linguagem<\/p>\n

SQL:
\ndatabase<\/strong>
\nALTER DATABASE databaseName CHARSET = UTF8 COLLATE = utf8_general_ci; \/\/utf8_unicode_ci
\ntable<\/strong>
\nALTER TABLE tableName CONVERT TO CHARACTER SET utf8;
\nfor a specific column in a table<\/strong>
\nALTER TABLE columnName COLLATE utf8_general_ci<\/p>\n

: esse i no final \u00e9 ignora busca sensecade, minuscula e maiuscula<\/em><\/p>\n

Entenda\u00a0CHARSET e COLLATE<\/h2>\n

CHARSET e COLLATE s\u00e3o coisas distintas, no MySQL, cada CHARSET possui COLLATEs, cada um com sua particularidade. O intuito deste Wiki n\u00e3o \u00e9 explicar as caracter\u00edsticas de cada um deles, pois pode ser visto da documenta\u00e7\u00e3o do MySQL, mas daremos um pequeno descritivo entre latin1_general_ci, latin1_general_cs e latin1_swedish_ci.<\/p>\n

COLUNA texto, tamanhos<\/h2>\n

Type | Maximum length
\n———–+————————————-
\nTINYTEXT | 255 (2 8\u22121) bytes
\nTEXT | 65,535 (216\u22121) bytes = 64 KiB
\nMEDIUMTEXT | 16,777,215 (224\u22121) bytes = 16 MiB
\nLONGTEXT | 4,294,967,295 (232\u22121) bytes = 4 GiB<\/p>\n

Type | A= worst case (x\/3) | B = best case (x) | words estimate (A\/4.5) – (B\/4.5)
\n———–+—————————————————————————
\nTINYTEXT | 85 | 255 | 18 – 56
\nTEXT | 21845 | 65,535 | 4854.44 – 14,563.33
\nMEDIUMTEXT | 5,592,415 | 16,777,215 | 1,242,758.8 – 3,728,270
\nLONGTEXT | 1,431,655,765 | 4,294,967,295 | 318,145,725.5 – 954,437,176.6<\/p><\/blockquote>\n

 <\/p>\n

Tive este mesmo problema e consegui resolver da seguinte maneira:
\nNo meu arquivo de conex\u00e3o com o banco, coloquei o c\u00f3digo abaixo:<\/p>\n

echo utf8_encode($exibe[‘recadao_mensagem’]);
\nou
\nmysql_query(“SET NAMES ‘utf8′”);
\nmysql_query(‘SET character_set_connection=utf8’);
\nmysql_query(‘SET character_set_client=utf8’);
\nmysql_query(‘SET character_set_results=utf8’);
\nou
\nini_set(‘default_charset’, ‘UTF-8’);<\/p>\n","protected":false},"excerpt":{"rendered":"

Artigo 1 Artigo 2 Usando PHP Caso precise codificar e descodificar, \u00e9 nesta ordem: utf8_encode() > html_entity_decode() > htmlentities() e em \u00faltimo caso, se nada disso funcionar, use o header(‘content-type text\/html charset=utf-8’); Usando META TAGS <meta charset=”utf-8″> <meta http-equiv=”Content-Type” content=”text\/html; charset=UTF-8″ > Conex\u00e3o PDO MySQL (PDO): $dsn = “mysql:host=localhost;dbname=world;charset=utf8”; MySQL MySQL: CREATE DATABASE nome_bd CHARACTER […]<\/p>\n","protected":false},"author":1,"featured_media":565,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-466","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","has-thumbnail"],"_links":{"self":[{"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/posts\/466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/comments?post=466"}],"version-history":[{"count":2,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/posts\/466\/revisions"}],"predecessor-version":[{"id":469,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/posts\/466\/revisions\/469"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/media\/565"}],"wp:attachment":[{"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/media?parent=466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/categories?post=466"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/tags?post=466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}