Results 1 to 6 of 6
Mar 3, 2013, 13:55 #1
- Join Date
- Feb 2011
- 0 Post(s)
- 0 Thread(s)
Save lowercase username or make case insensitive queries?
Duplicate millions of username to faster search or use LOWER queries? Or in other words how slow is LOWER(username)=LOWER('$username').
I guess use LOWER is the way but I'm concerned about the performance of using LOWER.
I'm using utf8_bin, so my MySQL is case sensitive, I should stop using it, at least for that table?