My Recommendations. I use this successfully in several multiple language
projects.
# my.cnf
[mysqld]
default_character_set = utf8
character_set_client = utf8
character_set_server = utf8
[client]
default_character_set = utf8
#php.ini
default_charset = "utf-8"
#httpd.conf
AddDefaultCharset UTF-8
<VirtualHost>
AddCharset UTF-8 .htm
</VirtualHost>
MySQL connection (extra precaution)
SET NAMES utf8;
HTML
<meta charset="utf-8">
PHP
header('Content-type: text/html; charset=UTF-8');
And last but not least, even editing files in shell can be affected (.e.g
UTF-8 data to be inserted into DB from file). Ensure
LC_CTYPE=en_US.UTF-8
LANG=en_US.UF-8
Regards
Ronald
01110010 01101111 01101110 01100001 01101100 01100100 00100000 01100010
01110010 01100001 01100100 01100110 01101111 01110010 01100100
*Ronald Bradford
*
MySQL Expert specializing in Performance Tuning, Scalability and High
Availability
Author - Effective MySQL: Optimizing SQL
Statements<http://effectivemysql.com/book/optimizing-sql-statements/>
-
2011, Co-author - Expert PHP and MySQL <http://expertphpandmysql.com/> -
2010
All-time top MySQL Blogger -
2011<http://mysqlpreacher.com/wordpress/2011/01/mysql-community-blogging-%E2%80%93-planetmysql-part-2/>
, Oracle ACE Director -
2010<http://apex.oracle.com/pls/otn/f?p=19297:4:134763154226248::NO:4:P4_ID:1820>
, MySQL Community Member of the Year -
2009<http://www.mysql.com/why-mysql/awards/community-2009.html>
Web Site: http://ronaldbradford.com
Linked In: http://www.linkedin.com/in/ronaldbradford
Twitter: @RonaldBradford <http://twitter.com/ronaldbradford>,
@MySQLExpert <http://twitter.com/MySQLExpert>
Skype: RonaldBradford
_______________________________________________
New York PHP User Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
http://www.nyphp.org/show-participation
