webamine.fr (User)
Posts: 6
|
| Can't create MySql databases with uppercase name 2008/09/26 03:53 |
|
|
Hi,
I have a problem with virtualmin to create databases with upper case
names (using "edit databases" on a virtualmin host). it only creates
lower case names.
So I have to go in webmin to create theses bases, but then the database
is not linked correctly to the user / host and so I have to do some
part of the job manually.
Do you have an idea where this could come from please ?
Thx.
Post edited by: webamine.fr, at: 2008/09/26 04:01
|
|
|
|
The administrator has disabled public write access. |
jmarsden (User)
Posts: 13
|
| Re:Can't create MySql databases with uppercase name 2008/09/29 14:51 |
|
|
deleted duplicate post.
Post edited by: jmarsden, at: 2008/09/29 15:39
--
Jonathan Marsden
|
|
|
|
The administrator has disabled public write access. |
Joe (Admin)
Posts: 4124
|
| Re:Can't create MySql databases with uppercase name 2008/09/29 14:57 |
|
|
There's some reason for that code...but I don't remember what it is. (And it may not be a useful reason in this particular case, or even in the general case. It could very well be an edge case issue that most people would never see. I dunno. What I'm saying is, "try it and see".)
|
|
|
|
The administrator has disabled public write access. |
jmarsden (User)
Posts: 13
|
| Re:Can't create MySql databases with uppercase name 2008/09/29 15:38 |
|
|
The comments for that function don't give any hint of a reason, either, saying only:
# If a database name starts with a number, convert it to a word to support
# PostgreSQL, which doesn't like numeric names. Also converts . and - to _,
# and handles reserved DB names.
It would be better coding practice to include some comment regarding the lowercasing of database names in there, I think.
--
Jonathan Marsden
|
|
|
|
The administrator has disabled public write access. |
jmarsden (User)
Posts: 13
|
| Re:Can't create MySql databases with uppercase name 2008/09/29 15:38 |
|
|
The comments for that function don't give any hint of a reason, either, saying only:
# If a database name starts with a number, convert it to a word to support
# PostgreSQL, which doesn't like numeric names. Also converts . and - to _,
# and handles reserved DB names.
It would be better coding practice to include some comment regarding the lowercasing of database names in there, I think.
--
Jonathan Marsden
|
|
|
|
The administrator has disabled public write access. |
webamine.fr (User)
Posts: 6
|
| Re:Can't create MySql databases with uppercase name 2008/10/07 04:31 |
|
|
Ok, so it's like some feature to adapt databases for compatibility ?
It was a little troublesome because we imported databases and parts of
databases from other servers, so we had to adapt either the code or
the databases names manually to fit.
Regards,
François.
|
|
|
|
The administrator has disabled public write access. |
|
