Hello Folks,
I need help with case sensitivity in column types. I'm using MySQL.
My table has two columns for LOGIN and PASSWORD. Since these are small words, I use VARCHAR(20) instead of TINYBLOB.
My problem is that all comparisons I do on these two columns are case insensitive. I don't wanna use TINYBLOB, because I feel it's too big for login/password.
Is there any other way of making my comparisons case sensitive, besides using tinyblob? Thanks.
Richie.
I need help with case sensitivity in column types. I'm using MySQL.
My table has two columns for LOGIN and PASSWORD. Since these are small words, I use VARCHAR(20) instead of TINYBLOB.
My problem is that all comparisons I do on these two columns are case insensitive. I don't wanna use TINYBLOB, because I feel it's too big for login/password.
Is there any other way of making my comparisons case sensitive, besides using tinyblob? Thanks.
Richie.