El 5/12/09 4:18 PM, Petr Kadlec escribió:
2009/5/12 Lars Aronsson<lars(a)aronsson.se>se>:
Petr Kadlec wrote:
It is exactly this attitude of "oh, it's so difficult" that has
blocked bug 164 from being fixed.
Well, not really. Bug 164 would be fixed almost completely for
Czech-language wikis by using database features designed for exactly
this problem. [1] But, I guess you know the situation.
* Not available until MySQL 5 migration complete (Domas, what's the
status on testing?)
* Collation use for sorting needs to be double-checked to confirm it
wouldn't interfere with present uniqueness constraints
* Collations not available in MySQL for all languages
* Multilingual sites possibly not well served by table-wide
language-specific coding
Doing our own localized sort key encoding and adding another indexed
column to sort on would avoid some dependency issues but has its own
deployment and maintenance difficulties.
It would also be possible to use a separate column for the collated
sorting while using MySQL 4.1+'s native collations, if the uniqueness
constraints are a problem, but this is still dependent on rolling out an
upgrade from 4.0.
-- brion