Results 1 to 2 of 2
  1. #1
    techissue2008 is offline Member
    Join Date
    May 2008
    Rep Power

    Question MySQL Case Sensitive Problem


    I have a jsp website which requires users to fill up verification code which is case sensitive when users register or login. However, if user signed in with Capital letter (according to the code image generated), it returned error. If user signed in using all small cap, it is ok. Is it related to MySQL problem? I use MySQL 5.0, can I just add lower_case_table_names=0 to my.ini and fix that problem?

    Thanks for advice.

  2. #2
    Celestz is offline Member
    Join Date
    Jun 2008
    Rep Power


    why not try catching the user input then use toUpper to simplify your problem?

Similar Threads

  1. problem in connecting to mysql database
    By nancyv in forum Java Servlet
    Replies: 6
    Last Post: 04-02-2008, 12:33 PM
  2. Replies: 0
    Last Post: 03-29-2008, 04:36 PM
  3. problem with operator in case
    By jimJohnson in forum New To Java
    Replies: 2
    Last Post: 03-21-2008, 09:22 PM
  4. mysql driver problem
    By mokingsu in forum JDBC
    Replies: 4
    Last Post: 01-17-2008, 06:27 PM
  5. Mysql problem
    By Nick15 in forum JDBC
    Replies: 2
    Last Post: 05-15-2007, 06:07 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