UTF-8 and apache - mysql - php

Posted Tue, 09/08/2009 - 09:16 by ma

Settings a LAMP server to work in full unicode UTF-8 :

httpd.conf:

AddCharset UTF-8 .utf8
AddDefaultCharset UTF-8

php.ini

default_charset = "utf-8"

my.cnf

character-set-server=utf8
default-collation=utf8_unicode_ci

In all your PHP scripts : 

mysql_query("SET NAMES 'utf8';",$con);

Importing database :

mysql -h host -u username -p password --default_character_set utf8 database < file.sql

Dont forget to add UTF-8 in the head of all your HTML files :

<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>