[wp-trac] [WordPress Trac] #13103: "Unknown character set" during install into database reports successful install.

[WordPress Trac]

#13103: "Unknown character set" during install into database reports successful
install.
--------------------------+-----------------------------
 Reporter:  MECU          |       Owner:  barrykooij
     Type:  defect (bug)  |      Status:  assigned
 Priority:  normal        |   Milestone:  Future Release
Component:  Database      |     Version:  3.0
 Severity:  normal        |  Resolution:
 Keywords:  has-patch     |
--------------------------+-----------------------------

Comment (by pento):

 A couple of thoughts:

 `SHOW CHARACTER SET` was added in 5.0.3 - do we want a version check in
 `wpdb::has_cap()` for that?

 I suspect it may be possible to configure a MySQL server such that `SHOW
 CHARACTER SET` performs a case sensitive search, even though the related
 server variables are case insensitive. Ie, the following query fails:

 `SHOW CHARACTER SET WHERE Charset COLLATE 'utf8_bin' LIKE 'UTF8';`

 The query would allow for that as:

 `$wpdb->prepare( 'SHOW CHARACTER SET WHERE LOWER( Charset ) = LOWER( %s
 )', DB_CHARSET )`

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/13103#comment:13>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software