Philip:
Look at your server's startup directives (/etc/my.cnf) and see if the
following line appears:
set-variable = lower_case_table_names=1
This variable forces the server to use lower case.
We grappled with this issue, and solved it by:
- Running an ALTER script to use lower case names for tables and columns in
the database
- Set the variable to force lower case
- Did S&R on our source code to make everything conform to lower-case.
Once done, our case problems ceased, and teh same code works on both the
Win32 and Linux platforms.
Gerald Jensen
----- Original Message -----
From: "Philip Mak" <[EMAIL PROTECTED]>
To: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, August 19, 2001 9:21 AM
Subject: Re: Case-preserving is not consistent
On Sun, 19 Aug 2001, Sinisa Milivojevic wrote:
> If this is happening on Windows, we truly can not do anything about
> it.
>
> You could help there by forcing all table names to be lower-case by
> starting mysql service with a corresponding option.
No, it's happening on Linux. Here's a transcript of what happens. I create
a table called "test" with a column called "HELLO". Then when I execute
"modify column hello", the case of the column becomes "hello". This will
cause perl scripts that use $sth->fetchrow_hashref to fail.
pmak@trapezoid [/home/animel/www/include]# mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 813 to server version: 3.23.36
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> create table test (HELLO int);
Query OK, 0 rows affected (0.07 sec)
mysql> alter table test modify column hello int;
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> describe test;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| hello | int(11) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
1 row in set (0.00 sec)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
