Page MenuHomePhabricator

wikishared database has latin1 as the default encoding
Closed, ResolvedPublic


MariaDB [wikishared]> SHOW CREATE DATABASE wikishared;
| Database   | Create Database                                                       |
| wikishared | CREATE DATABASE `wikishared` /*!40100 DEFAULT CHARACTER SET latin1 */ |

This may mean new tables created could be in latin1 encoding instead of binary (the standard for mediawiki). Check existing tables, too.

Event Timeline

jcrespo raised the priority of this task from to Needs Triage.
jcrespo updated the task description. (Show Details)
jcrespo added projects: ContentTranslation, DBA.
jcrespo added subscribers: jcrespo, KartikMistry.

OK. Let's fix encoding for wikishared :)

(I had discussion with @santhosh on this)

Amire80 triaged this task as High priority.Sep 4 2015, 7:03 AM
Amire80 set Security to None.

This is blocker for T111317 (Review and create table for Content Translation).

This change was applied to this database on the master and all slaves:

MariaDB [wikishared]> SHOW CREATE DATABASE wikishared\G
*************************** 1. row ***************************
       Database: wikishared
Create Database: CREATE DATABASE `wikishared` /*!40100 DEFAULT CHARACTER SET binary */
1 row in set (0.00 sec)