Uppercase MySQL Tables

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Uppercase MySQL Tables

Postby uknowho008 » 03. November 2006 02:03

hi, i was just wondering if there is a way to make mysql tables allow uppercase letters. whenever i create a table like "News" mysql converts it to"news" it makes it difficult to export data from my computer database and import it to my webserver database. thanks for the help
uknowho008
 
Posts: 2
Joined: 03. November 2006 01:56

Postby Wiedmann » 03. November 2006 02:33

Well, there is a way, like you can read in the MySQL manual. But you realy should only use lowercase (ascii) letters and digits (and no spaces) for the identifiers to avoid problems.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby uknowho008 » 03. November 2006 02:34

i can understand why spaces might cause problems but how would using uppercase letters?
uknowho008
 
Posts: 2
Joined: 03. November 2006 01:56

Postby Wiedmann » 03. November 2006 02:59

MySQL stores all databases and tables in the filesytem. But each filesystem have it's own limitation (allowed directory/filenames).
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 93 guests