case sensitivity

[Anon]

hi,

i'm aware that blob and text differ in how they treat text sensitivity - but is there a way to check that a varchar/char using a case sensitive test (i'm using this for a username/password type thing, and i want them to be case sensitive)

i could convert them to blobs, but will this bog things down?

cheers

dom
🙂

[Anon]

Could be wrong.......but

Varchar should display the text in the same case that it was put in as.....so since variables are case sensitive also, you shouldn't have any worries.............I think?

regards,
scott d~

[Anon]

hiya,

its more the fact that mysql doesn't seem to care about case when using '=', so

select * from table where field = "Stuff"

produces the same result as

select * from table where field = "sTuFF"

hmm...

dom
🙂