Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Posts
    11

    Unanswered: create table Naming prob

    I've been creating table names using mixtures of capital letters and small letters but when it appeared on phpMyAdmin, all names are in small letters.
    Is it a problem with my phpMyAdmin settings or mysql? and how do i solve it.

    Thanks in advance.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). 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.

    -- 9.2.2. Identifier Case Sensitivity
    so you're on windows, right?

    there are examples on that page which tell you what to do about it
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2005
    Posts
    11
    yes im on windows, thanx for the link it was very helpful.
    would you recommend sticking with lower case for all table/databse names if i were to transfer tables between platforms that differ in filesystem case sensitivity?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, yes i would
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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