Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2000
    Location
    Washington, USA
    Posts
    5,991

    Cool MySQL case sensitivity

    Anyone have a work-around for case sensitive database and table names?

    E.g. you can reference the database in both upper and lower case.

    For reference the server is running FreeBSD and it's MySQL version 3.23.56

  2. #2
    Join Date
    Jun 2003
    Posts
    673
    Check out this page from the MySQL docs. There is a lower_case_table_names options to control this (dunno if it's supported in 3.23). If you set it to 1, you will need to stop MySQL and rename your files and directories to lowercase first.

  3. #3
    Join Date
    Jun 2000
    Location
    Washington, USA
    Posts
    5,991
    Thanks!

  4. Newsletters

    Subscribe Now & Get The WHT Quick Start Guide!

Related Posts from theWHIR.com

Posting Permissions

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