create table Naming prob

cfemocha · #1 (**permalink**) 02-26-06, 03:29

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.

r937 · #2 (**permalink**) 02-26-06, 05:40

Quote:

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

cfemocha · #3 (**permalink**) 02-26-06, 06:28

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?

r937 · #4 (**permalink**) 02-26-06, 08:23

yes, yes i would

Internet Services

Web Development

Digital Marketing

Consumer Tech