[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