{"id":614,"date":"2011-06-20T11:00:11","date_gmt":"2011-06-20T09:00:11","guid":{"rendered":"http:\/\/guimi.net\/blogs\/hiparco\/?p=614"},"modified":"2011-06-20T11:02:44","modified_gmt":"2011-06-20T09:02:44","slug":"configurar-juego-de-caracteres-charset-en-lamp-linux-apache-mysql-php","status":"publish","type":"post","link":"http:\/\/guimi.net\/blogs\/hiparco\/configurar-juego-de-caracteres-charset-en-lamp-linux-apache-mysql-php\/","title":{"rendered":"Configurar juego de caracteres (charset) en LAMP (Linux, Apache, MySQL, PHP)"},"content":{"rendered":"

Instalamos los paquetes necesarios:
\n# aptitude install apache2 mysql-server php5
<\/font>
\nModificamos la configuración de apache:
\n# vi \/etc\/apache2\/conf.d\/charset
<\/font><\/p>\n

...\r\nAddDefaultCharset       UTF-8\r\n...\r\n<\/pre>\n
\nModificamos la configuración de PHP:
\n# vi \/etc\/php5\/apache2\/php.ini
<\/font><\/p>\n
...\r\ndefault_charset = \"utf8\"\r\n...\r\n<\/pre>\n
En la cabecera de las páginas indicar:<\/p>\n
...\r\n<meta http-equiv=\"Content-Type\" content=\"text\/html; charset=utf-8\" \/>\r\n...\r\n<\/pre>\n
Y en los scripts PHP de conexión:<\/p>\n
...\r\n$sql_script(\"SET NAMES 'utf8'\");\r\n...\r\n<\/pre>\n
\nModificamos la configuración de MySQL:
\n# vi \/etc\/mysql\/my.cnf
<\/font><\/p>\n
...\r\nlanguage    = \/usr\/share\/mysql\/spanish\r\n...\r\n<\/pre>\n
\nY reiniciamos los servicios:
\n# \/etc\/init.d\/apache2 restart
\n# \/etc\/init.d\/mysql restart
<\/font>
\n<\/p>\n
En caso de tener una BB.DD. en otra codificación como iso-8859-1, conviene exportarla a un fichero de texto, convertir el fichero con “iconv bbdd.sql -f iso-8859-15 -t utf-8 -o bbdd_utf8.sql<\/font>” y volver a importarla.<\/p>\n
juego de caracteres, charset, Linux, Apache, MySQL, PHP<\/b><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Instalamos los paquetes necesarios: # aptitude install apache2 mysql-server php5 Modificamos la configuración de apache: # vi \/etc\/apache2\/conf.d\/charset … AddDefaultCharset UTF-8 … Modificamos la configuración de PHP: # vi \/etc\/php5\/apache2\/php.ini … default_charset = “utf8″ … En la cabecera de las páginas indicar: … <meta http-equiv=”Content-Type” content=”text\/html; charset=utf-8″ \/> … Y en los scripts PHP de […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,4,23,11],"tags":[],"class_list":["post-614","post","type-post","status-publish","format-standard","hentry","category-bbdd","category-gnulinux","category-redes","category-software-libre"],"_links":{"self":[{"href":"http:\/\/guimi.net\/blogs\/hiparco\/wp-json\/wp\/v2\/posts\/614","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/guimi.net\/blogs\/hiparco\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/guimi.net\/blogs\/hiparco\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/guimi.net\/blogs\/hiparco\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/guimi.net\/blogs\/hiparco\/wp-json\/wp\/v2\/comments?post=614"}],"version-history":[{"count":3,"href":"http:\/\/guimi.net\/blogs\/hiparco\/wp-json\/wp\/v2\/posts\/614\/revisions"}],"predecessor-version":[{"id":618,"href":"http:\/\/guimi.net\/blogs\/hiparco\/wp-json\/wp\/v2\/posts\/614\/revisions\/618"}],"wp:attachment":[{"href":"http:\/\/guimi.net\/blogs\/hiparco\/wp-json\/wp\/v2\/media?parent=614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/guimi.net\/blogs\/hiparco\/wp-json\/wp\/v2\/categories?post=614"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/guimi.net\/blogs\/hiparco\/wp-json\/wp\/v2\/tags?post=614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}