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 <[email protected]>
> 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
> [email protected]
> https://lists.wikimedia.org/mailman/listinfo/wikitech-l
>
_______________________________________________
Wikitech-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
