Results 1 to 2 of 2
  1. 06-09-2008, 07:37 PM #1
    techissue2008
    techissue2008 is offline Member
    Join Date
    May 2008
    Posts
    3
    Rep Power
    0

    Question MySQL Case Sensitive Problem

    Hi

    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.
    Reply With Quote Reply With Quote
  2. 06-10-2008, 06:23 AM #2
    Celestz
    Celestz is offline Member
    Join Date
    Jun 2008
    Posts
    3
    Rep Power
    0

    Default

    why not try catching the user input then use toUpper to simplify your problem?
    Reply With Quote Reply With Quote
« Regarding PreparedStatement | SQL Server Specializations »

Similar Threads

  1. problem in connecting to mysql database
    By nancyv in forum Java Servlet
    Replies: 6
    Last Post: 04-02-2008, 11:33 AM
  2. Problem with jTable that is binded with a table in MySQL Database
    By rajkenneth in forum NetBeans
    Replies: 0
    Last Post: 03-29-2008, 03:36 PM
  3. problem with operator in case
    By jimJohnson in forum New To Java
    Replies: 2
    Last Post: 03-21-2008, 08:22 PM
  4. mysql driver problem
    By mokingsu in forum JDBC
    Replies: 4
    Last Post: 01-17-2008, 05:27 PM
  5. Mysql problem
    By Nick15 in forum JDBC
    Replies: 2
    Last Post: 05-15-2007, 05:07 PM

Bookmarks

Posting Permissions

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

Forum Rules