RE: [Web-erp-developers] case sensitive table problem mysql linuxwindows

[jesse <je...@st...>]

Dick, please take a look at this:
http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html

The proper fix for this problem is listed there using the 'mysqld. =
lower_case_table_names' config option. I would say either 0 or 2 would =
work.=20
This also alleviates changing all table names which would be a nightmare =
in the code, for upgrades, etc.

Going forward the install docs need to reflect this caveat for windows =
mysql systems.

how's that sound?

-----Original Message-----
From: web...@li... =
[mailto:web...@li...]On Behalf Of =
Stins, Dick
Sent: Sunday, April 18, 2004 17:22
To: web...@li...
Subject: Re: [Web-erp-developers] case sensitive table problem mysql =
linuxwindows


Danie,

Thanks for the tip, but the mysql windows server is storing all tables =
in lowercase.=20
Dumping with quotes results still in lowercase table names (ofcourse =
between quotes).

I still think that it is the best to transform all tablenames to =
lowercase. This will give 100% full compatibility at this issue between =
web-erp at windows an web-erp at linux.

With best regards,

Dick Stins
----- Original Message -----=20
From: Danie Brink=20
To: Phil Daintree=20
Sent: Saturday, April 17, 2004 2:37 PM
Subject: Re: [Web-erp-developers] case sensitive table problem mysql =
linuxwindows


Hi Dick,
I have found this problem myself with MySQL , but found that by =
exporting with quotes it solved the problem, you should ask mysqldump to =
to do that, if I remember correctly you use the -Q command line option.

This might help or Not as I have never tried working with the windows =
version.

On Sat, 2004-04-17 at 10:19, Stins, Dick wrote:=20
Dear all,
=20
I have a very annoying problem.
=20
mysql at windows converts all table names to lower case.
=20
When you create a dump of the database, it's also converted to lowercase =
table names.
=20
When you import this at linux, it works fine except that all scripts =
expect case sensitive table names and are returning errors.
=20
After some study, I concluded that using only lowercase table names in =
scripts and in the mysql database is the best solution to keep the mysql =
data exchangeble between those platforms for all web-erp users.
=20
Another option is to create a seperate script to rename the tables at =
the unix platform back to case sensitive, but that crashed the mysql =
server completely (bug).=20
=20
I suspect that this might be caused by circular references in the =
foreign key definitions, but I am not sure about that.
=20
With best regards,
=20
Dick Stins
=20
p.s. I have a rename table script available for lowercase to uppercase =
conversion, when someone is interested.=20