https://bugzilla.wikimedia.org/show_bug.cgi?id=164
T. Gries <m...@tgries.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |m...@tgries.de
--- Comment #159 from T. Gries <m...@tgries.de> 2010-03-07 11:15:15 UTC ---
When setting up a new(!) wiki, and when using MySQL 4.1/5.0 UTF-8 (not: binary)
a correct page title sort order can be achieved when applying this patch
in maintenance/tables.sql change
page_title varchar(255) binary NOT NULL,
to
page_title varchar(255) NOT NULL,
before you run the installer.
The column page_title will then become of encoding type
character set utf8 collate utf8_general_ci
and the sorting order of page titles is correct for (at least European
languages). You then get page titles in Special:Pages listed in the order
"Anton", "Äpfel", "École supérieure", "Zulu" - and not any longer "Anton",
"Zulu", "Äpfel", "École supérieure" as is currently the case on all WMF wikis.
This tip is only valid for fresh installations: you cannot change this
important column when updating from an existing database even not when
mysqldumping and importing; attention: the tip has not yet checked for unwanted
side effects.
For collations see
[1] http://www.collation-charts.org/mysql60/ and
[2]
http://www.collation-charts.org/mysql60/mysql604.utf8_general_ci.european.html
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
