| Re: Database import [message #100 is a reply to message #95] |
Wed, 21 June 2006 17:24   |
AJM
Messages: 2369
Registered: April 2006
Location: Surrey, UK
|
Senior Member |
|
|
I have tried creating database names in mixed case with phpMyAdmin, MySQL-Front, MySQL Administrator and MySQL Query Browser without success - the names are always converted to all lower case.
The only way I can create database and table names with mixed case (on my Windows PC at least) is to create the files outside of any MySQL utility.
When the dict_database record is created the value which appears in database_id is downshifted and the subsys_id is set to '?' - this is normal behaviour. Querying the MySQL server to get any table names and column details works regardless of which case is used - sql queries are insensitive to case. The framework will use lower case for all database, table and column names without any problem.
In answer to your question - no, it does not matter if you have any databases in the dictionary which are not used by any scripts which are run under the Radicore framework.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
