El 5/12/09 4:18 PM, Petr Kadlec escribió:
2009/5/12 Lars Aronssonlars@aronsson.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