Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Collation

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2002-05-29 : 03:57:21
I have a table where in password is stored.
The password needs to be case sensitive.

I have got 2 options..
1>change the collation of the perticular column.
2>Compare the ascii value of password (from the front end application and password stored in the database..)

Thankx in advance...

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2002-05-29 : 04:01:36
forgot to ask..which option is better?

Go to Top of Page

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2002-05-29 : 04:46:48
Here's a response to this question previously:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12526

Search the forum for case sensitive. There are lots of postings on this topic.
Go to Top of Page
   

- Advertisement -