wikishared database has latin1 as the default encoding
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	jcrespo
	Sep 3 2015, 10:54 AM

Description

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.

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		jcrespo	T111317 Review and create table for Content Translation
		Resolved		jcrespo	T111333 wikishared database has latin1 as the default encoding

Event Timeline

jcrespo created this task.Sep 3 2015, 10:54 AM

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.

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 3 2015, 10:54 AM

jcrespo added a parent task: T111317: Review and create table for Content Translation.Sep 3 2015, 10:56 AM

jcrespo moved this task from Triage to Blocked external/Not db team on the DBA board.

KartikMistry added subscribers: • santhosh, Nikerabbit.Sep 3 2015, 12:47 PM

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 added a project: ContentTranslation-Release6.

Amire80 set Security to None.

Amire80 moved this task from Backlog to Translation suggestions on the ContentTranslation-Release6 board.

Amire80 moved this task from Needs Triage to CX6 on the ContentTranslation board.Sep 4 2015, 8:34 AM

Arrbee added a project: OKR-Work.Sep 7 2015, 6:51 AM

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

jcrespo added a project: Schema-change-in-production.Sep 9 2015, 11:15 AM

jcrespo moved this task from Blocked external/Not db team to In progress on the DBA board.Sep 10 2015, 9:48 AM

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)

jcrespo closed this task as Resolved.Sep 10 2015, 10:00 AM

jcrespo mentioned this in T112080: the bounce_records table in x1 wikishared has latin1 encoding.Sep 10 2015, 10:58 AM

wikishared database has latin1 as the default encodingClosed, ResolvedPublicActions

Description

Related ObjectsSearch...

Event Timeline

wikishared database has latin1 as the default encoding
Closed, ResolvedPublic
Actions

Related Objects
Search...