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(a)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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l