How to set case sensitivity in ms access database? I need it for password column.
Jigs28
0
Light Poster
Recommended Answers
Jump to PostWhat do you mean by set case sensitivity?
If you are comparing within c# the strings that you pull from the password field of the database will be compared case sensitive by default.
Jump to PostIt should do, i also tested this in visual studio to check if HeLlO matched Hello and it did not, you may wish to check your login validation code itself and not the mismatch of case sensitivity :)
Jump to PostUse the built in function StrComp, as in "SELECT StrComp('hello', 'Hello', 0)". It will return 0 if they are the same, otherwise -1 or 1.
All 10 Replies
Mike Askew
131
Veteran Poster
Featured Poster
Jigs28
0
Light Poster
Mike Askew
131
Veteran Poster
Featured Poster
Jigs28
0
Light Poster
Jigs28
0
Light Poster
Momerath
1,327
Nearly a Senior Poster
Featured Poster
Mike Askew
131
Veteran Poster
Featured Poster
Jigs28
0
Light Poster
Jigs28
0
Light Poster
Momerath
1,327
Nearly a Senior Poster
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.