Hello Friends,
my question is :
in my login table i have two fields
UserName nvarchar(24),
password nvarchar(24)

if i enter password in uppercases then on login it also accepts password in lower cases. plz tell me what should be the correct daatype for this.
is there is any option available for that


thanks......

__________________
thanks......

Hi,

since you're decide to use nvarchar datatype (char like data type) you must consider witch of SQL Collation options you want to apply to that datatype. In this case as I can see you want it to be case sensitive (CS) (something like "Latin1_General_CS_AS") and therefore you should pick up right collation.

Just, have in mind that both comparing and sorting of char like datatypes uses collation rules that you have specified..

there is also a server parameter to treat capital letters the same as lower case, problem could be as mrJagodic describes or this.

Yes, you can configure your server to be case sensitive or not. That should solve your problem.

cheers.

_________________________
- Vijay G
Strive for Perfection

Ooooohhhh... If you want case sensitivety, do it by the column using COLLATION... don't make the whole server case sensitive. I've worked for two clients that did and it was a bloody nightmare.

--Jeff Moden