Hoi, There is no need to ask people to define collation orders. This is exactly what the CLDR (an Unicode standard) is there for. Thanks, GerardM
2009/5/13 Domas Mituzas midom.lists@gmail.com
Hi
- Not available until MySQL 5 migration complete (Domas, what's the
status on testing?)
I did testing just for binary schema, I'm happy about application support part, need some DBA-ish features to be merged though :)
Still, do note, that MySQL5 supports only BMP, and will cut strings if there's anything beyond BMP in there.
- Collation use for sorting needs to be double-checked to confirm it
wouldn't interfere with present uniqueness constraints
It will. If you want proper sorting, you'll end up using case- insensitive unique constraints.
- Collations not available in MySQL for all languages
Well, we can ask people to describe those collations themselves, in theory. In practice - too much work, and people would just have to use generic UCI sorting rules.
- Multilingual sites possibly not well served by table-wide
language-specific coding
Generic Unicode is good enough, usually.
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.
There's one more issue - if we go for utf8 columns, 255-character limit is somewhat big. Are we going to reduce column sizes? What problems would that bring upon us?
Cheers, Domas http://dammit.lt/
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l