No announcement yet.

Case sensitivity

  • Filter
  • Time
  • Show
Clear All
new posts

  • Case sensitivity


    I have a linux reseller account. Is is possible to set MySQL to be case insensitive?

    Thanks Stu

  • #2
    My understanding of this part of the reference you gave "...Consequently, the case sensitivity of the underlying operating system determines the case sensitivity of database and table names. This means database and table names are case sensitive in most varieties of Unix, and not case sensitive in Windows" means that no, you probably cannot make MySQL case-insensitive, however I'm no outright expert on this.

    For these sorts of questions I'd normally email Support directly ...

    Too many nice toys too little time to play with 'em!


    • #3
      I agree with 247h - if your on shared unix hosting there is virtually zero chance of getting the default changed.

      Out of interest - why would you want it case insensitive in the first place?
      David Allen -


      • #4
        one can compile Aspell Pspell with Apache to ignore case but this is limited to webpages served by Apache. I've never seen anything for MySQL so far.
        eUKhost - eNlight Cloud Hosting || eUKhost Knowledgebase
        Toll Free : 0808 262 0255 || Skype : mark_ducadi


        • #5
          Originally posted by DavidAllen View Post
          Out of interest - why would you want it case insensitive in the first place?
          A programming colleague was just being lazy. He used SQL Server queries like this
          select * from PRODUCTS;
          select * from proudcts;
          Which would never have worked.

          Anyway he sorted it now he is using upper-case throughout.

          Cheers Stu
          Last edited by stukelly; 15-10-2007, 12:26.


          • #6
            Case sensitivity is not any users property that can be changed. It is related to system, once it is defined then further changing is not possible.


            • #7
              So there is no easy way of changing this value ( lower_case_table_names ) in an excisting database/table?

              I am hosting a few websites on a vps hosting account and one of my clients asked if he could change this on his account.