overlordq wrote:

More of a pedantic bug afaik since the 'order of operations' is column>table>database>server charset/collation.

connection collation goes in there somewhere too.

• Bug 11859 has been marked as a duplicate of this bug. ***

This is still true as of 1.21-something in git. It affects eg the searchindex table, which does not have a character set specified at creation time, see maintenance/tables.sql for that. Someone reloading a table via LOAD DATA INFILE will get bitten by this too, as that will check the database default iirc.

karun.84 wrote:

I am going to start looking at what is causing this, and I plan to write a patch.

karun.84 wrote:

I have submitted a patch for this bug. I am proposing to change the default character set to UTF8, as the sindex table cannot be in binary format, and all other tables will be set to binary when created, if the binary format is chosen in the installer.

(In reply to comment #5)

I have submitted a patch for this bug. I am proposing to change the default
character set to UTF8, as the sindex table cannot be in binary format, and
all
other tables will be set to binary when created, if the binary format is
chosen
in the installer.

Patch is https://gerrit.wikimedia.org/r/#/c/67422/

(In reply to comment #6)

Patch is https://gerrit.wikimedia.org/r/#/c/67422/

Karun: Thanks for the patch! See http://www.mediawiki.org/wiki/Gerrit/Commit_message_guidelines for how to get automatic notification in the corresponding bug report.

Change 67422 merged by jenkins-bot:
MysqlInstaller: use default character set of utf8

https://gerrit.wikimedia.org/r/67422

Patch got merged on 2013-09-24, hence closing as FIXED.
Karun: Thanks again for contributing this patch!