Livre d'or
Livre d'or

Gazettearticles à enrichir
Que pensez-vous de Vikidia ? Venez mettre un message sur le livre d'or !

Vikidia:Tech/Call for proposals/Fix Encoding

Aller à la navigation Aller à la recherche

Context[modifier | modifier le wikicode]

We experience a bug with https://fr.vikidia.org/wiki/Sp%C3%A9cial:Contributions/%E9%BC%A0 . Also, collations in database are sometimes in latin1 instead of utf8. Also, default charset in database are incorrectly in latin1.

Challenge[modifier | modifier le wikicode]

Fix the bugs on the test server, maybe with a change in localsettings database configuration.

We don't want to see anywhere the latin1 anymore, on every database.

Propose an SQL script or something else to run in production and fix every database incorrect collation.

Deliverable[modifier | modifier le wikicode]

  • A merge request respecting general coding guidelines
  • Deployed on a test server (provided by Vikidia), where we can validate the fix
  • A procedure to deploy it in production, like the script

Comments[modifier | modifier le wikicode]

  • Unknown complexity. NB: Database is pretty big ("fr" is 20GiB) and it needs hours to run scripts. Plyd (discussion) 21 mai 2021 à 15:08 (CEST)