On Tue, Jun 8, 2010 at 10:28 AM, Paul Houle <paul(a)ontology2.com> 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.)