Results 1 to 3 of 3

Thread: Case sensitive in sql statement > MySql db..?

  1. #1

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Case sensitive in sql statement > MySql db..?

    Hi

    Just a qustion, probably me being slack due to MS Access allowing non case sensitive matches in sql statements, but weird.

    The XAMPP on the machine appears to allow it (ie SELECT * FROM tblUsers or SELECT * FROM tblusers) but the one I'm hosting on (free and just to show other people) wont open the queries unless the tables match exactly.

    Is there a setting on MySql that can allow any case sensitive naming..?
    Or is it a setting on the PHP Online server (older version I think)..?

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

  2. #2
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,123

    Re: Case sensitive in sql statement > MySql db..?

    Are you using a non-Windows OS by any chance?

    http://dev.mysql.com/doc/refman/5.0/...nsitivity.html
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  3. #3

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Case sensitive in sql statement > MySql db..?

    Ah hmmm maybe.. Windows here... but the server on the free hoster might be unix or linux...

    Ok that makes sense.

    Thanks

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

Posting Permissions

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



Click Here to Expand Forum to Full Width