On Tue, Jun 8, 2010 at 10:28 AM, Paul Houle <[email protected]> wrote:
>     As a person who has labored mightily to make sense of dbpedia,  I
> think that one reason why varbinary is preferable to varchar in many
> applications in wikimedia is that varchar() string comparisons are case
> insensitive and varbinary comparisons are case sensitive.

varchar with binary or utf8_bin collation is case-sensitive.  It
doesn't sort as nicely, though.  (AFAIK.)

_______________________________________________
Wikitech-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Reply via email to