query | Andronicus

Solution to DISTINCT Case Problem

2018-03-06 Credential Research No Comments

First off, take a look at my post from yesterday. I was given to understand that DISTINCT is not case-sensitive. The issue at hand actually has less to do with DISTINCT itself, and more to do with the character set and collation that are used when comparing strings. The best…

DISTINCT – Not as Sensitive as You Think

2018-03-05 Credential Research No Comments

If you’ve ever used DISTINCT in a mysql query, you’ll want to pay very close attention to what I am going to say next. It is not case-sensitive. “This” and “this” are equal, and it will only return one of them. When you’re hashing strings, these two strings produce different…