Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    Senior Coder crmpicco's Avatar
    Join Date
    Jan 2005
    Location
    Mauchline, Scotland
    Posts
    1,094
    Thanks
    15
    Thanked 1 Time in 1 Post

    make login case-sensitive with MySQL database

    I have a MySQL database. A user logs in to my site using a form. (at www.crmpicco.co.uk)

    UserName
    Password

    How can i make the login case sensitive?

    My script is ASP with JavaScript.

    Merci.

    Picco

  • #2
    New Coder
    Join Date
    Aug 2006
    Location
    UK
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This very much depends on implementation. I would have thought unless you were upper / lower-casing usernames and passwords, by default it would be case sensitive?

  • #3
    Senior Coder crmpicco's Avatar
    Join Date
    Jan 2005
    Location
    Mauchline, Scotland
    Posts
    1,094
    Thanks
    15
    Thanked 1 Time in 1 Post
    when i login with maplank as the username it doesnt differentiate between maplank and MaPlank (what is in the DB)

  • #4
    New Coder
    Join Date
    Aug 2006
    Location
    UK
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [Edited because I was talking complete rubbish... just goes to show: do *NOT* assume all DBMS's are equal!]
    Last edited by Phill; 08-18-2006 at 04:08 PM.

  • #5
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    See the manual, you can force a case sensitive search quite easily performing a case sensitive search.

    The problem of course is that you can't store unique names in such a field. that is because Dave and dave would both be seen as equivalent as far as non-unique names. but if you don't set the field as unique and do search as the above link suggests then you are all set.

    By default I'm not sure if that is true of only windows or not but know that the two would be unique under linux/unix.

    The link above though also has a link to making the column case sensitive then I guess you could have those two users be recognized as unique.
    Last edited by guelphdad; 08-18-2006 at 03:42 PM.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •