password case problem

Last post 12-25-2007 9:10 AM by doto777. 3 replies.

Sort Posts:

  • password case problem

    12-25-2007, 5:40 AM
    • Member
      41 point Member
    • doto777
    • Member since 11-03-2007, 2:50 AM
    • Posts 35

    I am using login control now the problem is that when password is entered it checks password form sql but does not check case.

     

    what ever the case is in sql databse it hardly matters to m code. how d i correct it where i am wrong.

     

    please help me.

    Filed under:
  • Re: password case problem

    12-25-2007, 7:34 AM
    Answer
    • Contributor
      2,090 point Contributor
    • aadreja
    • Member since 02-03-2007, 11:36 AM
    • Ahmedabad, India
    • Posts 354

    its because by default SQL Server is case insensitive.
    for implementing case sensitive queries you have to change your password column

    SELECT * FROM tablename WHERE mypassword='password entered by user' sql_latin1_general_cp1_cs_as

    using sql_latin1_general_cp1_cs_as collation you can write case sensitive queries in SQL Server

    for further information you can look at this article http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm

    Thanks,
    Ritesh

    ---------------------------------------------
    Please do not forget to mark as Answer if my reply is helpful.
  • Re: password case problem

    12-25-2007, 8:21 AM
    Answer
    नमस्ते,
    [KaushaL] || BloG || MS MVP

    "I would love to change the world, but they won’t give me the source code"


    Don't forget to click "Mark as Answer" on the post that helped you.
    This credits that member, earns you a point and mark your thread as Resolved for the sake of Future Readers.
  • Re: password case problem

    12-25-2007, 9:10 AM
    • Member
      41 point Member
    • doto777
    • Member since 11-03-2007, 2:50 AM
    • Posts 35

    thanks both of you.

     

    i havent tried it but i guess it will work.

     

    thanks once again

Page 1 of 1 (4 items)