T. Gries <> changed:

           What    |Removed                     |Added
                 CC|                            |

--- Comment #159 from T. Gries <> 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,
  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] and 

Configure bugmail:
------- 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

Reply via email to