[wp-trac] [WordPress Trac] #2828: ease MySQL4.1 character set configuration

WordPress Trac wp-trac at lists.automattic.com
Fri Jun 16 04:41:12 GMT 2006


#2828: ease MySQL4.1 character set configuration
-----------------------+----------------------------------------------------
       Id:  2828       |      Status:  new                     
Component:  General    |    Modified:  Fri Jun 16 04:41:11 2006
 Severity:  normal     |   Milestone:  2.1                     
 Priority:  normal     |     Version:  2.1                     
    Owner:  anonymous  |    Reporter:  tenpura                 
-----------------------+----------------------------------------------------
 MySQL4.1 and later, character set configuration become complicated and
 this annoys people. The problem is that if the person has no permission to
 modify my.cnf, the only solution so far is to hardcode a MySQL query to
 the core file such as wp-db.php. This is not easy for everyone.[[BR]]
 http://www.google.com/search?hl=en&q=%22SET+NAMES%22+%22wp-db.php%22

 Most people execute "SET NAMES 'utf8'" query right after the database
 connection is made. This will set session values of 4 MySQL system
 variables (character_set_client, character_set_connection,
 character_set_results, collation_connection) to utf8. In most cases this
 operation is necessary because these values default to latin1. The only
 solution I can think of is to control this from wp-config.php. (see
 attachment)

 What I want to say is that this is everybody's issue including English
 users, because if one gets garbled UTF-8 international trackbacks or
 comments on his UTF-8 WP, that means his WP may be misconfigured.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/2828>
WordPress Trac <http://wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list