Need help with case insensitive select

[rain13]

Hello I am having problem with case insensitive select: I have tried.

SELECT LOWER( Name )FROM `users`WHERE LOWER(`Name`) = LOWER('somename')

and

SELECT LOWER( Name )FROM `users`WHERE LOWER(`Name`) LIKE LOWER('somename')

But I get MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0006 sec ). when somename has some upper case letters. How do I construct case insensitive select?Edit: I have also tried SELECT Name FROM users WHERE Name LIKE 'somename' but as soon as I change case of 'somename' it doesn't find anything.Edit: it didnt work because table was in binary encoding.

Edited December 24, 2012 by SoItBegins