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

[Stins, D. <DR...@Zi...>]

Jesse,

Thanks, but I read also the user comments. This scared me off. And it is
dependend of the configuration of mysql, so you keep the problem when the
mysql database is configured with different parameters.

Changing the table names is independent of everything and solves this iss=
ue
for ever (although I was surprised that mysql uses lowercase. Oracle uses
standard uppercase, but this will be compatible with unquoted tablenames =
in
create table scripts.).

For changing the scripts, I hoped that you are a wizard with unix shell
scripting and convert the table names to lowercase within a few minutes f=
or
all scripts.

For renaming tablenames in the database is a little harder. I think we ne=
ed
to do:
- backup the database
- dump the data separately from the create table scripts.
- Rename the table names in this script with the unix shell scripting tri=
ck.
- drop all tables
- create tables (with lowercase names) like a new installation (complete
empty tables + constraints)
- insert the data

With best regards,

Dick Stins

p.s. I tried the the rename table statement, but that crashed the complet=
e
mysql server process.

----- Original Message -----
From: "jesse" <je...@st...>
To: <web...@li...>
Sent: Monday, April 19, 2004 12:06 AM
Subject: RE: [Web-erp-developers] case sensitive table problem mysql
linuxwindows


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 wo=
rk.
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 my=
sql
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.
Dumping with quotes results still in lowercase table names (ofcourse betw=
een
quotes).

I still think that it is the best to transform all tablenames to lowercas=
e.
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 -----
From: Danie Brink
To: Phil Daintree
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:
Dear all,

I have a very annoying problem.

mysql at windows converts all table names to lower case.

When you create a dump of the database, it's also converted to lowercase
table names.

When you import this at linux, it works fine except that all scripts expe=
ct
case sensitive table names and are returning errors.

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.

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).

I suspect that this might be caused by circular references in the foreign
key definitions, but I am not sure about that.

With best regards,

Dick Stins

p.s. I have a rename table script available for lowercase to uppercase
conversion, when someone is interested.



-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id638&op=3Dick
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers