> nolan@celery.tssi.com wrote:
> MySQL also does case independent text comparisions, and
> apparently ONLY case-insensitive comparisons.
It's not very clearly described in the manual. But if you either specify
your textual fields 'binary' or use some form of 'like ... binary' query
it'll compare them case-sensitive, (apart from the strcmp-functions).
And in the case of a binary textual field the indices are also
case-sensitive :)
Regards,
Arjen
